Sage X3 V7 to Product update 9 report not working

SUGGESTED

Hi ,

We updated from x3 V7 to Product v9  , but after the update the customised reports are appearing empty , can somebody advise what could be the issue here please ;

Thanks

  • 0
    SUGGESTED

    Hello,

    Typically when a report prints blank the first steps to is to run a Database trace to find out what is the query passed to database.

    For example if you are using SQL, you can using profiler trace and determine the statement passed to database, and then run that statement directly in the database to determine if a result is shown and troubleshoot from there.

    Keep in mind that the table structures might change between versions, so take a look at online help for the structure of the tables in your report.


    Regards,

  • 0 in reply to Esfahani
    Hi,
    I am also in similar issue. After update from V7 to PU9, the standard PR,PO printouts not working..
    I tried the trace. The code is shows below.

    exec sp_execute 263,N'POH',N'ADMIN',73,N'SHM-PO-17-000004~',N'ADMIN',N'ADMIN','2017-03-19 11:15:43','2017-03-20 07:51:13',0x59B43B23F80B2D47B77B441BB93CE5BC,10603

    When I try to run this Query in SQL Server, I am getting error:

    Msg 8179, Level 16, State 4, Procedure sp_execute, Line 1
    Could not find prepared statement with handle 263.


    Can you please check..?
    Thanks.