Fusion Transportation Intelligence (fti) Screen Has Odbc Exception

[surender]

Hi All,

We have done the FTI Installation,when we are accessing KPI watch list under Dash board for transportation intelligence following error is coming:

"Unit Of Measures "

View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError:
23006] The session variable, NQ_SESSION.CURRENCY, has no value definition.
(HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT MAX(Period."Year"), VALUEOF(NQ_SESSION.CURRENCY), VALUEOF(NQ_SESSION.DENSITY),
VALUEOF(NQ_SESSION.DISTANCE), VALUEOF(NQ_SESSION.DURATION),
VALUEOF(NQ_SESSION.LENGTH), VALUEOF(NQ_SESSION.SPEED),
VALUEOF(NQ_SESSION.TEMPERATURE), VALUEOF(NQ_SESSION.VOLUME),
VALUEOF(NQ_SESSION.WEIGHT) FROM "Advanced Analytics"')}

SQL Issued: SELECT MAX(Period."Year"), VALUEOF(NQ_SESSION.CURRENCY), VALUEOF(NQ_SESSION.DENSITY),
VALUEOF(NQ_SESSION.DISTANCE), VALUEOF(NQ_SESSION.DURATION),
VALUEOF(NQ_SESSION.LENGTH), VALUEOF(NQ_SESSION.SPEED),
VALUEOF(NQ_SESSION.TEMPERATURE), VALUEOF(NQ_SESSION.VOLUME),
VALUEOF(NQ_SESSION.WEIGHT) FROM "Advanced Analytics"

Can anyone help in this regard?

[anirban1982]

Re: Fusion Transportation Intelligence (fti) Screen Has Odbc Exception

Hi Surender,

We are also getting the same error. Plesae let me know what needs to be done to rectify it. Thanks in advance.

Regards,
Anirban Roy

[catchmecm]

Re: Fusion Transportation Intelligence (fti) Screen Has Odbc Exception

Hi Anirban/Surender,

CAn anyone of you please share the documents for FTi isntallation? That would be a great help.

Regards

[Louise Hebert]

Re: Fusion Transportation Intelligence (fti) Screen Has Odbc Exception

Hi,

Did anyone get this working? I have the same error. Any help would be appreciated.