时间戳

首页 > 解决方案 > 在 OBIEE 中运行报告时出错 -> [SQL_STATE: HY000] [nQSError: 10058] 发生一般错误

obiee - 在 OBIEE 中运行报告时出错 -> [SQL_STATE: HY000] [nQSError: 10058] 发生一般错误

问题描述

在 OBIEE（Oracle 商业智能工具）中运行报告时出现以下错误。谁能给我解决方案如何解决？

Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
Location: saw.views.evc.activate, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 27002. [nQSError: 27002] Near <interval>: Syntax error (HY000)
State: HY000. Code: 26012. [nQSError: 26012] . (HY000)
SQL Issued: {call NQSGetLevelDrillability('SELECT cast(year("Call Date"."Call Date") as char(4)) || right(''0'' || cast (month("Call Date"."Call Date") as varchar(2)), 2) saw_0, "My Operator"."My PMN (TADIG) Code" saw_1 FROM "GSM Analysis Roaming Outbound (Home)" WHERE "Call Date"."Call Date" BETWEEN TimeStampAdd(SQL_TSI_DAY, -(DayOfMonth(Current_Date)), TimeStampAdd(SQL_TSI_MONTH, -12, Current_Date)) + interval 1 day AND TimeStampAdd(SQL_TSI_DAY,-(DayOfMonth(Current_Date)), TimeStampAdd(SQL_TSI_MONTH, -0, Current_Date))')}

标签： obiee

解决方案

您在该分析中正在进行的所有可怕公式中都有语法错误（不是“报告”！而是“分析”）。您必须逐列分解分析，然后找到产生问题的计算。

推荐阅读