Saad Faisal
Member
Hi Everyone
First of all, i am a newbie on JDE and utilizing the DEMO environment of JDE E1 9.1 and just starting to grasp the basic ideas, starting with Table Conversion. My current objective is to
Using the "Data Conversion" type in TC to export the F4101 table to an external SQL Server Table.
For this purpose, i have created a database on my SQLServer with a single table that is an exact replica of F4101. Then i followed the points mentioned on this URL
http://jdejosh.blogspot.com/2011/02/tc-foreign-table.html
to setup my Environment, DataSource, OCM Mapping. But when i try to select my OUTPUT Environment in "Data Conversion" i am getting the following error
"Unable to Initialize output environment"
Upon close inspection of the JDE.log, i am seeing the following error
----------------------------------------
2200/4064 MAIN_THREAD Mon Mar 18 20:17:18.920140 Jdb_omp1.c1779
JDB9900419 - Either no roles assigned to user DEMO or roles are not valid for the signon environment SQLF4101.
2200/4064 MAIN_THREAD Mon Mar 18 20:17:18.920159 Jdb_ctl.c4423
JDB9901500 - No role associated with the *ALL. Failed to signon the user.
2200/4064 MAIN_THREAD Mon Mar 18 20:17:18.936188 Jdb_ctl.c6051
JDB1200001 - Failed to validate Environment handle
-----------------------------
For my SQLF4101 Environment, i have checked my OCM Mapping and i have a "DEFAULT" Object Name Mapping with my DataSource "SQLSRVRDS" with System ROLE as "*PUBLIC" and it is also Activated. Infact i have also added a similar mapping with user "DEMO" and even with User Role "DEMOROLE" but i am still receiving this error. So i am just constantly scratching my head on what is that i am doing wrong.
Here are some more details of my environment
OS: Windows 7 x64
JDE Ver: E1 9.1 (DEMO Installation)
Any help would be appreciated.
First of all, i am a newbie on JDE and utilizing the DEMO environment of JDE E1 9.1 and just starting to grasp the basic ideas, starting with Table Conversion. My current objective is to
Using the "Data Conversion" type in TC to export the F4101 table to an external SQL Server Table.
For this purpose, i have created a database on my SQLServer with a single table that is an exact replica of F4101. Then i followed the points mentioned on this URL
http://jdejosh.blogspot.com/2011/02/tc-foreign-table.html
to setup my Environment, DataSource, OCM Mapping. But when i try to select my OUTPUT Environment in "Data Conversion" i am getting the following error
"Unable to Initialize output environment"
Upon close inspection of the JDE.log, i am seeing the following error
----------------------------------------
2200/4064 MAIN_THREAD Mon Mar 18 20:17:18.920140 Jdb_omp1.c1779
JDB9900419 - Either no roles assigned to user DEMO or roles are not valid for the signon environment SQLF4101.
2200/4064 MAIN_THREAD Mon Mar 18 20:17:18.920159 Jdb_ctl.c4423
JDB9901500 - No role associated with the *ALL. Failed to signon the user.
2200/4064 MAIN_THREAD Mon Mar 18 20:17:18.936188 Jdb_ctl.c6051
JDB1200001 - Failed to validate Environment handle
-----------------------------
For my SQLF4101 Environment, i have checked my OCM Mapping and i have a "DEFAULT" Object Name Mapping with my DataSource "SQLSRVRDS" with System ROLE as "*PUBLIC" and it is also Activated. Infact i have also added a similar mapping with user "DEMO" and even with User Role "DEMOROLE" but i am still receiving this error. So i am just constantly scratching my head on what is that i am doing wrong.
Here are some more details of my environment
OS: Windows 7 x64
JDE Ver: E1 9.1 (DEMO Installation)
Any help would be appreciated.