Report Portal

All Forums  ReportPortal General Forum  Report Portal General Issues  Subscription issues on IBM DB2 SQL reports

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Message: * HTML is ON * Forum Code is OFF Smilies [quote][i]Originally posted by fdranguet[/i] [br]Hello, after switching from RP 185 to RP 186, we are now facing some issues with subscriptions on SQL reports that were created against an IBM DB2 connection; they are failing with an error message that I am pasting at the end of this post. I am not sure what is happening, I am wondering if this could be due to some change in the scheduler scripts that are trying for some reason to select a unique value from the DB in the form "select xxxx", which works fine in SQL Server but is failing in IBM DB2 (you need to have "select xxxx from sysibm.sysdummy1"). Many thanks for your help ! Regards, Fran�ois -------------------------------------------------------------------- ERROR [42000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>. ERROR [01000] [IBM][System i Access ODBC Driver]Extended dynamic support disabled.; SQL: select 1015 at ReportPortal.DbManager.GetSingleSqlValue(String sSql, ConnectInfo oConnectInfo) at ReportPortal.SqlReportExport.?(Boolean bDefaultFormula, String sDefaultValue, DataTable& oTable) at ReportPortal.SqlReportExport.FilterQuery(String sQuery, Boolean bUserFilter, String sJobId) at ReportPortal.SqlReportExport.�(String reportId, Boolean bUserFilter, Boolean bXml, String sJobId, String sTranspose) at ReportPortal.Scheduler.?(String sReportId, String sReportType, String sJobId, String sDeliveryType, String sContentType, String iLanguageId, String sToUserId, String sToUserName, String sToEmail, String sToNtUserId, String sToNtPassword, String sConditionOperator, String iConditionRow, String iConditionCol, String sConditionValue, String sMultiCondition, String& sMultiConditionOut, String& sStylePage, String& sReportHtml, String& sError, String& sMDX, String& sReportDesc, String& sFilterLabel, Boolean& bConditionMet, String& sStyleThemeId, String sReportName, String sTempPath, String& sFilePath, String sXmlaProperties) [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.