My Oracle Support Banner

12C Issue With Visual Analyzer "Create Data Source" (Doc ID 2326777.1)

Last updated on APRIL 24, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

After upgrade From 12.2.1.0.0 to 12.2.1.x.x version

Issue with Visual Analyzer "Create Data Source"

The issue is with Visual Analyzer when trying to create a data connection with two different source:
1) From a File
2) From Oracle Applications

Also issue is specific to one particular environment where other environments works fine

Issue 1/Environment 1: After launching VA and selecting "Create Data Source",  get three options: "From a File", "From Oracle Applications" & "From Database". After selecting "From Oracle Applications", the progress bard (blue in color) seems to go from Left to Right and almost reaches the right side of the window but it seems to hang and does not display a window for entering new connection information.

Issue 2/Environment 1: After launching VA and selecting "Create Data Source", get three options: "From a File", "From Oracle Applications" & "From Database". After selecting "From a File", able to browse for the file but when i select and upload it, it does not upload the file. The error message is: File upload failed. .xlsx is an invalid file. Only Microsoft Office Open XML Workbook Files (.xlsx) are supported.

The following error occurs in managed server log

[bi_server1] [ERROR] [] [oracle.bi.web.datasetsvc.metadata] [tid: [ACTIVE].ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: b06896d9-6de5-46d5-abdc-2a47ab704072-00019b26,0:2] [APP: bidatasetsvc] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] [ODL_TRACE_ID: 3-13083657911-VAIssue] [SRC_CLASS: oracle.bi.web.datasetsvc.dbstorage.DBDirectoryProvider] [SRC_METHOD: insertMetadata] insertion of metadata failed[[
java.sql.SQLSyntaxErrorException: ORA-00904: "CONNECTION_ID": invalid identifier

Request status(500) : error = {"code":50000,"message":"DSS understood the request, but unable to perform the operation due to internal error","subMessage":"Unable to commit the dataset to Directory Service"}sss

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.