In Enterprise Manager, right click the database. To work around the issue, do the following to set the Compatibility Level of the Database to 80: You may also sign up for automatic notification of Services on our website. This SMR has been fixed in R07670 Service Pack and subsequent Service Packs, please check or website ( for availability of Service Packs for your General Ledger. Reports with Reference Codes, TREF, TPROJ receive error against SQL 2005 DB. This error occurs in any one of the following three instances:įDM 6.0 and 7.0 - Error in GL Zoom in row format against SQL 2005 database.įRL13, FDM 6.0 and 7.0 - Error launching Report Wizard against a SQL 2005 DB. ![]() In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes When I select OK it says 'Error 5 Invalid procedure call or argument (source: QSRules)', and then it says, 'The report date could not be loaded due to the following error: (5) Invalid procedure call or argument'. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). ![]() ![]() To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |