Hi Guys,
Today i am configuring my reporting service on AX 2013 R3 while configuring when i validate report Server setting in Microsoft dynamics ax i came across the below mentioned issue
"Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Service URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager."
after searching on internet i have found nothing, finally wasting the whole day i got the solution myself.
Here is the solution,
Steps to follow,
1.Run Microsoft dynamics ax client with admin account "Run as administrator"
2. Now go to report server setting in system administrator and then validate settings
3. succeeded
Cause: SQL reporting server / SQL Server is install by local user not administrator
Happy Daxing,
Showing posts with label Web service URL. Show all posts
Showing posts with label Web service URL. Show all posts
Tuesday, June 27, 2017
Synchronization through x++ code / Unable to do DB Sync through AOT
Synchronization forcefully DB through X++
here is the code for synchronization DB in X++.
static void DBSync(Args _args )
{
Dictionary dict;
int idx,lastIdx,totalTables;
TableId tableId;
Application application;
SysOperationProgress progress;
StackBase errorStack;
ErrorTxt errorTxt;
application = new Application();
dict = new Dictionary();
totalTables = dict.tableCnt();
progress = new SysOperationProgress();
progress.setTotal(TotalTables);
progress.setCaption("TEst");
errorStack = new StackBase(Types::String);
lastIdx = 0;
try
{
for (idx = lastIdx + 1; idx <= totalTables ; idx++)
{
tableId = dict.tableCnt2Id(idx);
progress.setText(dict.tableName(tableId));
lastIdx = idx;
application.dbSynchronize(tableId,false,true,false);
progress.incCount();
}
}
catch(Exception::Error)
{
errorTxt = strFmt("Error in table '%1 (%2)'",tableId,dict.tableName(tableId));
errorStack.push(errorTxt);
retry;
}
setPrefix('Test2');
errorTxt = errorStack.pop();
while (errorTxt)
{
error(errorTxt);
errorTxt = errorStack.pop();
}
}
now run job.
Subscribe to:
Posts (Atom)