ecosentino
Member
Hello everyone,
I am trying to access a foreign table from within the JDE environment. I have read all the posts on this topic and believe I have followed all the appropriate steps. The problem is as follows
The UBE I created works as expected on the Fat Client and returns all rows I am expecting, but when I run the same UBE on the web client I get "No data selected".
We are on 9.1 on the AS400.
Here are the steps I followed
1. Created a VIEW using Create View command.
2. Created a table in E1 that matches the view I created in step 1 above. Same table name and same columns (type and size)
2.1- I did not generate this table
3. Created a E1 view based on the table from step 2.
At this point I am able to query the E1 table within the UTB on the fat client. So I assumed I was on the right track
4. Created a simple UBE, using the Business View I created, that lists all the records in the E1 table. When I run this UBE on the fat client t works as expected.
5. Deployed table, Business view and UBE to DV and PY
5. when I run the UBE on the web client, The report says no data selected.
Note: If I use databrowser from web client and query the E1 table, the records are displayed. I get the same results when I query the business view in databrowser. it is just the UBE that is not working.
Did I miss something? All suggestions would be appreciated.
Thanks,
I am trying to access a foreign table from within the JDE environment. I have read all the posts on this topic and believe I have followed all the appropriate steps. The problem is as follows
The UBE I created works as expected on the Fat Client and returns all rows I am expecting, but when I run the same UBE on the web client I get "No data selected".
We are on 9.1 on the AS400.
Here are the steps I followed
1. Created a VIEW using Create View command.
2. Created a table in E1 that matches the view I created in step 1 above. Same table name and same columns (type and size)
2.1- I did not generate this table
3. Created a E1 view based on the table from step 2.
At this point I am able to query the E1 table within the UTB on the fat client. So I assumed I was on the right track
4. Created a simple UBE, using the Business View I created, that lists all the records in the E1 table. When I run this UBE on the fat client t works as expected.
5. Deployed table, Business view and UBE to DV and PY
5. when I run the UBE on the web client, The report says no data selected.
Note: If I use databrowser from web client and query the E1 table, the records are displayed. I get the same results when I query the business view in databrowser. it is just the UBE that is not working.
Did I miss something? All suggestions would be appreciated.
Thanks,