get_activity_for_account_check

POST /redrock/query

{
	"Script":"@/lib/server/get_activity_for_account_check.js"
}

{
    "success": false,
    "Result": null,
    "Message": "Query has failed: near \"var\": syntax error",
    "MessageID": "_I18N_RedrockQuery",
    "Exception": "Centrify.Cloud.Query.RedrockQueryException: Query has failed: near \"var\": syntax error ---> System.Data.SQLite.SQLiteException: SQL logic error or missing database\r\nnear \"var\": syntax error\r\n   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)\r\n   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()\r\n   at System.Data.SQLite.SQLiteDataReader.NextResult()\r\n   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)\r\n   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Centrify.Cloud.Redrock.QueryEngine2.SqliteWrapper.Database.ExecuteQuery(String sql, IEnumerable`1 args, Action`1 action)\r\n   at Centrify.Cloud.Redrock.QueryEngine2.QueryInterface.ExecuteQueryInternal(String sql, DatabasePoolEntry db, IEnumerable`1 args)\r\n   at Centrify.Cloud.Redrock.QueryEngine2.QueryInterface.<>c__DisplayClass7_1.<ExecuteQuery>b__1()\r\n   at Centrify.Cfw2.Core.Diagnostics.Navel.Lint.Drop(Action action)\r\n   at Centrify.Cloud.Redrock.QueryEngine2.QueryInterface.RentDB(Action`1 action)\r\n   at Centrify.Cloud.Redrock.QueryEngine2.QueryInterface.ExecuteQuery(String sql, IEnumerable`1 args)\r\n   at Centrify.Cloud.Core.Persistence.Engines.Azure.AzureTabularStorageContext.SqlQuery(String sql, Int32 skip, Int32 take, IEnumerable`1 args)\r\n   at Centrify.Cloud.Core.Persistence.Engines.Funnel.FunneledTablularStorageContext.SqlQuery(String sql, Int32 skip, Int32 take, IEnumerable`1 args)\r\n   at Centrify.Cloud.Core.Persistence.Engines.Instrumented.InstrumentedTabularStorageContext.<>c__DisplayClass13_0.<SqlQuery>b__1()\r\n   at Centrify.Cfw2.Core.Diagnostics.Navel.Lint.Drop[T](Func`1 func)\r\n   at Centrify.Cloud.Core.Persistence.Engines.Instrumented.InstrumentedTabularStorageContext.<>c__DisplayClass13_0.<SqlQuery>b__0()\r\n   at Centrify.Cfw2.Core.Diagnostics.Navel.Lint.Drop[T](Func`1 func)\r\n   at Centrify.Cloud.Core.Persistence.Engines.Instrumented.InstrumentedTabularStorageContext.SqlQuery(String sql, Int32 skip, Int32 take, IEnumerable`1 args)\r\n   at Centrify.Cloud.Query.QueryEngine.<>c__DisplayClass19_0.<ExecuteQuery>b__0()\r\n   --- End of inner exception stack trace ---\r\n   at Centrify.Cloud.Query.QueryEngine.<>c__DisplayClass19_0.<ExecuteQuery>b__0()\r\n   at Centrify.Cfw2.Core.Diagnostics.Navel.Lint.Drop[T](Func`1 func)\r\n   at Centrify.Cloud.Query.QueryEngine.<>c__DisplayClass12_2.<DoQuery2>b__4()\r\n   at Centrify.Cloud.Core.TenantContext.AsBlessedRole(String role, Func`1 allowBlessing, Action action)\r\n   at Centrify.Cloud.Core.TenantContext.AsBlessedRole(String role, Action action)\r\n   at Centrify.Cloud.Query.QueryEngine.<>c__DisplayClass12_0.<DoQuery2>b__0()\r\n   at Centrify.Cfw2.Core.Diagnostics.Navel.Lint.Drop[T](Func`1 func)\r\n   at Centrify.Cloud.Query.RedRockController.<Query>b__2_0()\r\n   at Centrify.Cloud.Core.RestHelpers.JsonRest.StandardJsonResult(Func`1 action)",
    "ErrorID": "4a62a48a-5dcc-44f2-a24d-ff7882db7f79:c204062bb9b54fac90a08ea5892ddc7b",
    "ErrorCode": null,
    "InnerExceptions": [
        {
            "Detail": "System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database\r\nnear \"var\": syntax error\r\n   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)\r\n   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()\r\n   at System.Data.SQLite.SQLiteDataReader.NextResult()\r\n   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)\r\n   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)\r\n   at Centrify.Cloud.Redrock.QueryEngine2.SqliteWrapper.Database.ExecuteQuery(String sql, IEnumerable`1 args, Action`1 action)\r\n   at Centrify.Cloud.Redrock.QueryEngine2.QueryInterface.ExecuteQueryInternal(String sql, DatabasePoolEntry db, IEnumerable`1 args)\r\n   at Centrify.Cloud.Redrock.QueryEngine2.QueryInterface.<>c__DisplayClass7_1.<ExecuteQuery>b__1()\r\n   at Centrify.Cfw2.Core.Diagnostics.Navel.Lint.Drop(Action action)\r\n   at Centrify.Cloud.Redrock.QueryEngine2.QueryInterface.RentDB(Action`1 action)\r\n   at Centrify.Cloud.Redrock.QueryEngine2.QueryInterface.ExecuteQuery(String sql, IEnumerable`1 args)\r\n   at Centrify.Cloud.Core.Persistence.Engines.Azure.AzureTabularStorageContext.SqlQuery(String sql, Int32 skip, Int32 take, IEnumerable`1 args)\r\n   at Centrify.Cloud.Core.Persistence.Engines.Funnel.FunneledTablularStorageContext.SqlQuery(String sql, Int32 skip, Int32 take, IEnumerable`1 args)\r\n   at Centrify.Cloud.Core.Persistence.Engines.Instrumented.InstrumentedTabularStorageContext.<>c__DisplayClass13_0.<SqlQuery>b__1()\r\n   at Centrify.Cfw2.Core.Diagnostics.Navel.Lint.Drop[T](Func`1 func)\r\n   at Centrify.Cloud.Core.Persistence.Engines.Instrumented.InstrumentedTabularStorageContext.<>c__DisplayClass13_0.<SqlQuery>b__0()\r\n   at Centrify.Cfw2.Core.Diagnostics.Navel.Lint.Drop[T](Func`1 func)\r\n   at Centrify.Cloud.Core.Persistence.Engines.Instrumented.InstrumentedTabularStorageContext.SqlQuery(String sql, Int32 skip, Int32 take, IEnumerable`1 args)\r\n   at Centrify.Cloud.Query.QueryEngine.<>c__DisplayClass19_0.<ExecuteQuery>b__0()",
            "Message": "SQL logic error or missing database\r\nnear \"var\": syntax error",
            "MessageID": "_I18N_System.Data.SQLite.SQLiteException"
        }
    ]
}