4 Replies Latest reply on Sep 12, 2014 8:05 PM by marcio.gomes

    The Report Designer exception in the LANDesk console

    marcio.gomes Rookie

      Hi there,

       

      I'm using Landesk 9.5 SP2...

      I'm making an report to list IP parts and using a query like this:

       

      SELECT SUBSTR(A1.DEFGTWYADDR,5,7) AS "COL1", A1.DEFGTWYADDR AS "COL2" From ldk.TCP A1

       

      in Dataset. But when use preview, the report hangs with the message:

       

      DataDynamics.Reports.ReportsException: An unexpected error occured.

      Additional information: 'ORA-00904: "SUBTO_CHAR": invalid identifier ORA-00904: "SUBTO_CHAR": invalid identifier' ---> System.Data.OleDb.OleDbException: ORA-00904: "SUBTO_CHAR":

      invalid identifier ORA-00904: "SUBTO_CHAR": invalid identifier

      at #LTe.#uue.ExecuteReader(IDbConnection connection, IDbTransaction transaction, #PTe expressionEvaluatorFactory) 

       

      The interesting is that when i use the same query in DataSet of report (rdlx) in a local installation of Data Dynamics Reports... (WORKS FINE);