[cool_brat]

Hi,

Could some one let me know if there is any documentation available for the FTI dash board set up,

I have tried to add a few KPI's to My Dash board section, but when I open the dash board, I receive this error:

" 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: 23013] An error occurred when extracting the metadata definition for the Attribute '"Fusion Transportation Intelligence"."D_SHIPMENT"."SHIPMENT_GID_LINK"'. [nQSError: 23005] The repository variable, WEB_SERVER, has no value definition. (HY000)

SQL Issued: {call NQSGetQueryColumnInfo('SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment Details"."Start Time", "- Stop Delivery Details"."Actual Arrival", "- Stop Delivery Details"."Planned Arrival", "Destination Geography"."Destination Country", "Destination Geography"."Destination Province", "Destination Geography"."Destination Region", "Destination Geography"."Destination XID", "Source Geography"."Source Country", "Source Geography"."Source Province", "Source Geography"."Source Region", Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week, substring("- Stop Delivery Details"."AA Shipment GID" ,Position(''.'' IN "- Stop Delivery Details"."AA Shipment GID")+1,length("- Stop Delivery Details"."AA Shipment GID" )), sum("- Stop Delivery Fact"."Total On Time Count")*100/sum("- Stop Delivery Fact"."Total Stops") FROM "Fusion Transportation Intelligence"')}


SQL Issued: SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment Details"."Start Time", "- Stop Delivery Details"."Actual Arrival", "- Stop Delivery Details"."Planned Arrival", "Destination Geography"."Destination Country", "Destination Geography"."Destination Province", "Destination Geography"."Destination Region", "Destination Geography"."Destination XID", "Source Geography"."Source Country", "Source Geography"."Source Province", "Source Geography"."Source Region", Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week, substring("- Stop Delivery Details"."AA Shipment GID" ,Position('.' IN "- Stop Delivery Details"."AA Shipment GID")+1,length("- Stop Delivery Details"."AA Shipment GID" )), sum("- Stop Delivery Fact"."Total On Time Count")*100/sum("- Stop Delivery Fact"."Total Stops") FROM "Fusion Transportation Intelligence"




"

Please let me know If I am missing something in the setups.

[nick.polites]

This is one of two bugs that I found as part of the OBI install.

Here is my documentation of the issues. Make sure to restart OTM after you update these.

-Log into the database as hdowner and run the following select statement select * from f_base_uom. If more than one UOM_TYPE of volume is returned you must delete all but one. It is recommended that you keep the most common one which is “CU FT”.

-Via SQL Backdoor you’ll need to update the OTM_WEB_SERVER parameter which is found in the REPORT_COMMON_PROPERTIES table. The update statement should look something like:

update REPORT_COMMON_PROPERTIES set REPORT_COMMON_PROPERTY_VALUE = 'http://otm.oracle.com/GC3 where REPORT_COMMON_PROPERTY_GID='OTM_WEB_SERVER'

[cool_brat]

Thanks, Nick

I will have our technical team run these processes and get back in case we have further issues.

Regards
Vipin

[bkirchmeyer]

Nick,

Related to this issue, only "CUFT" exists for the UOM_TYPE of "VOLUME" in the f_base_uom table.

After the other update mentioned (to REPORT_COMMON_PROPERTIES) you mentioned a restart of OTM. Do we need to restart all servers/apps or just the FTI/OBIEE server?

Thanks,
Ben

[nick.polites]

For that change to take, it would require the restart of the OTM app and web servers, but I would also restart OBI/FTI as well.

[bkirchmeyer]

Originally Posted by nick.polites

update REPORT_COMMON_PROPERTIES set REPORT_COMMON_PROPERTY_VALUE = 'http://otm.oracle.com/GC3 where REPORT_COMMON_PROPERTY_GID='OTM_WEB_SERVER'

Quick question:
Should this update be done on the Primary database (not the ROD)?

[nick.polites]

On the primary.

[raghulakshman]

Hi Nick,

We are facing the same issue and getting the below error. As suggested by you we have verified values in F_BASE_UOM table and has only one value for "VOLUME" which is CU FT. Could you suggest possible root cause for this issue?

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 23013] An error occurred when extracting the metadata definition for the Attribute '"Fusion Transportation Intelligence"."D_SHIPMENT"."SHIPMENT_GID_LINK"'. [nQSError: 23005] The repository variable, WEB_SERVER, has no value definition. (HY000)

SQL Issued: {call NQSGetQueryColumnInfo('SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment Details"."Shipment Date", "Destination Geography"."Destination Country", "Destination Geography"."Destination Province", "Destination Geography"."Destination Region", "Destination Geography"."Destination XID", "Source Geography"."Source Country", "Source Geography"."Source Province", "Source Geography"."Source Region", "Source Geography"."Source XID", "Transport Mode"."Mode XID", 1, Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week, substring("- Shipment Details"."AA Shipment GID",Position(''.'' IN "- Shipment Details"."AA Shipment GID")+1,length("- Shipment Details"."AA Shipment GID")) FROM "Fusion Transportation Intelligence"')}


SQL Issued: SELECT "- OLTP Shipments".SHIPMENT_GID_LINK, "- Shipment Details"."Shipment Date", "Destination Geography"."Destination Country", "Destination Geography"."Destination Province", "Destination Geography"."Destination Region", "Destination Geography"."Destination XID", "Source Geography"."Source Country", "Source Geography"."Source Province", "Source Geography"."Source Region", "Source Geography"."Source XID", "Transport Mode"."Mode XID", 1, Carrier."Carrier XID", Period."Day of Week", Period."Month", Period."Year", Period.Event, Period.Holiday, Period.Quarter, Period.Season, Period.Week, substring("- Shipment Details"."AA Shipment GID",Position('.' IN "- Shipment Details"."AA Shipment GID")+1,length("- Shipment Details"."AA Shipment GID")) FROM "Fusion Transportation Intelligence"

Thanks,
Raghu Lakshman

[Kristof Stevens]

We have following issue :

Connection between OTM and FTI is working fine and users are able to use the dashboard....

For an unknown reason the Oracle BI Javahost / SAW Server is loosing his connection (randomly) and we have to run this script ./run-saw.sh stop/start again
to solve the issue. Any idea why? :

On /oraclebi/OracleBIData/web/log/javahost.out.log :

Sep 16, 2009 11:20:21 AM MessageProcessorImpl processMessage
WARNING: Unexpected exception. Connection will be closed
java.io.EOFException
at com.siebel.analytics.web.sawconnect.sawprotocol.SA WProtocol.readInt(SAWProtocol.java:167)
at com.siebel.analytics.javahost.MessageProcessorImpl .processMessage(MessageProcessorImpl.java:133)
at com.siebel.analytics.javahost.Listener$Job.run(Lis tener.java:223)
at com.siebel.analytics.javahost.standalone.SAJobMana gerImpl.threadMain(SAJobManagerImpl.java:205)
at com.siebel.analytics.javahost.standalone.SAJobMana gerImpl$1.run(SAJobManagerImpl.java:153)
at java.lang.Thread.run(Thread.java:619)

Thx in advance,

Kristof Stevens

[l_kator]

Try:
1.You mast install Oracle BI client on Windiws mashin(if necessary)
2. Open Oracle BI Administration tools (start/program/oracle business inelligence/Administaration )
3. Open online(if BI Server on this computer) or offline (If BI Server run on other computer) repository Advanced_analytics
4. Check repository variable WEB_SERVER(Manage/Variables/Dynamic/WEB_SERVER)
5. Set Default Initializer to 'http://OTMhost:OTMport/GC3' and press Check IN Changes (in my company it 'http://oas.ebs:85/GC3' )
If repository was opened offline, you mast restart all BI sevices