NarasimhaRao
Member
Hello,
I am trying to use BIPublisher 10.1.3.4 enterprise by creating a jdbc connection to JDE E1. The jdbc connection is established successfully.
But when I try to create a SQL/Datamodel in the report, I am encountering different types of errors. The list of tables are listed when I click Query builder. But,
1. If I select any table there, it is giving "[SECURITY_ERROR] A Security error occured"
2. I wrote a SQL query as
"SELECT F0150.MAPA8
FROM JDE.F0150 F0150"
and when tried to execute the report I am getting this error:
"[SPEC_NOT_FOUND] Unable to find OneWorld specification for MAPA8.
"
3. Some times, It allows to create the query from the query builder but when tried to execute, throwing error
"Unable to parse operation"
4. When tried to execute a simple statement to retrieve all columns from the table, following error is occuring:
[BSFN_CALLOBJECT_ERROR] An error occurred during the call to trigger business function F0101_FETCHAFTER: COSE#1010 Remote environment initilization failed. Please see Enterprise Server log for details, env. maynot be supported by server: JDB_ERR: FAILED TO LOAD ENV.
The following simple queries works:
SELECT PA8, AN8
FROM JDE.F0150
WHERE AN8>100
SELECT *
FROM JDE.F0150
WHERE AN8>100
But the same is not happening with the below query:
SELECT AN8
FROM JDE.F0101
Please suggest if there is any change in the notation of the query or anything is missing from the above query. Also what are the specific care to be taken when writing a query involving more than 1 JDE tables.
If anybody have encountered similar errors, or know the solution for this, please advise us.
Thank you
Narasimha
I am trying to use BIPublisher 10.1.3.4 enterprise by creating a jdbc connection to JDE E1. The jdbc connection is established successfully.
But when I try to create a SQL/Datamodel in the report, I am encountering different types of errors. The list of tables are listed when I click Query builder. But,
1. If I select any table there, it is giving "[SECURITY_ERROR] A Security error occured"
2. I wrote a SQL query as
"SELECT F0150.MAPA8
FROM JDE.F0150 F0150"
and when tried to execute the report I am getting this error:
"[SPEC_NOT_FOUND] Unable to find OneWorld specification for MAPA8.
"
3. Some times, It allows to create the query from the query builder but when tried to execute, throwing error
"Unable to parse operation"
4. When tried to execute a simple statement to retrieve all columns from the table, following error is occuring:
[BSFN_CALLOBJECT_ERROR] An error occurred during the call to trigger business function F0101_FETCHAFTER: COSE#1010 Remote environment initilization failed. Please see Enterprise Server log for details, env. maynot be supported by server: JDB_ERR: FAILED TO LOAD ENV.
The following simple queries works:
SELECT PA8, AN8
FROM JDE.F0150
WHERE AN8>100
SELECT *
FROM JDE.F0150
WHERE AN8>100
But the same is not happening with the below query:
SELECT AN8
FROM JDE.F0101
Please suggest if there is any change in the notation of the query or anything is missing from the above query. Also what are the specific care to be taken when writing a query involving more than 1 JDE tables.
If anybody have encountered similar errors, or know the solution for this, please advise us.
Thank you
Narasimha