Hello
I am new at OBI. I am creating a report and I am getting the next error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes:
OPR4ONWY:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. Please have your System Administrator look at the log for more details on this error. (HY000)
Please have your System Administrator look at the log for more details on this error.
This happens once I used a formula in two columns.I have columns A and B, they are very similar, almost the same except for one value ("Submission Dates"."Offer Accepted Date" against "Submission Dates"."Hire Start Date").
Column A
(SUM(SUM(CASE WHEN "Requisition Status - Current"."Current Status" = 'Filled' THEN (TIMESTAMPDIFF(SQL_TSI_DAY,(CASE WHEN "Requisition Identification"."Req. Identifier" IN ('1004932','1004933'','1100495') THEN TO_DATETIME('2010-01-01','yyyy-mm-dd') ELSE "Requisition Dates"."Req. Creation Date" END), "Submission Dates"."Offer Accepted Date")+1)-"Requisition Aging"."Time On Hold Since Creation" END) BY "Requisition Identification"."Req. Identifier"))/(CASE WHEN "Submission CSW Status - Current"."Current Status Name" = 'Cleared for Hire/Proceed to OnBoarding'THEN COUNT("Submission General Info"."Submission Identifier") END)
Column B
(SUM(SUM(CASE WHEN "Requisition Status - Current"."Current Status" = 'Filled' THEN (TIMESTAMPDIFF(SQL_TSI_DAY,(CASE WHEN "Requisition Identification"."Req. Identifier" IN ('1004932','1004933'','1100495') THEN TO_DATETIME('2010-01-01','yyyy-mm-dd') ELSE "Requisition Dates"."Req. Creation Date" END), "Submission Dates"."Hire Start Date")+1)-"Requisition Aging"."Time On Hold Since Creation" END) BY "Requisition Identification"."Req. Identifier"))/(CASE WHEN "Submission CSW Status - Current"."Current Status Name" = 'Cleared for Hire/Proceed to OnBoarding'THEN COUNT("Submission General Info"."Submission Identifier") END)
If I run the report with those formulas the report runs, but without results. If I change the last part of the formula after the / and put this :
(SUM(COUNT(CASE WHEN "Submission CSW Status - Current"."Current Status Name" = 'Cleared for Hire/Proceed to OnBoarding' THEN "Submission General Info"."Submission Identifier" END) BY "Submission General Info"."Submission Identifier" )) it runs and I get results, but only If a put that in one column. If I want to put that in column A and B at the same time it will give me the error you saw at the begging.
