When I try to edit any datawindow data source PB is given me the following error and cannot go in graphic mode.
Table "table_name" as no columns; possible invalid table format...
The problem occurs also when I try to create new datawindow PB cannot find any tables.
The problem come from the SQL (show below) the where clause look for the table_schema 'system', is there a way to tell PB to look to another specific schema for example 'MY_SCHEMA' ?
SELECT TABLE_NAME,TABLE_COMMENT,IF(TABLE_TYPE='BASE TABLE', 'TABLE', TABLE_TYPE),TABLE_SCHEMA
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA LIKE 'system'
AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' )
AND TABLE_NAME LIKE 'RS\\_TRANSPORT' ORDER BY TABLE_SCHEMA, TABLE_NAME;