Question

Pega 8.1.3 BIX error: table doesn't exist in target Database: PegaBixRepo

Hi,

we have setup BIX extraction rule in pega 8.1.3.

PostgreSQL server is the DB backend to which the extrcation rule should send data. we have setup the DB in pega and tested the connectivty.

On running the extract rule - we get the below error:

2019-05-21 10:38:37,211 [ PegaRULES-Batch-4] [ ] [ ABC:01.01.01] ( internal.access.ExtractImpl) INFO mpg - Processing extract rule with insKey :RULE-ADMIN-EXTRACT INT-TTT-GSM-ABC-WORK-ABCEXCEPTION TESTEXTRACT1 #20190521T102002.770 GMT
2019-05-21 10:38:37,219 [ PegaRULES-Batch-4] [ ] [ ABC:01.01.01] ( internal.access.ExtractImpl) INFO mpg - bix/useHistoryClasses setting has been disabled
2019-05-21 10:38:38,761 [ PegaRULES-Batch-4] [ ] [ ABC:01.01.01] ( internal.access.ExtractImpl) INFO mpg - Processing Class: INT-TTT-GSM-ABC-WORK-ABCEXCEPTION with 3882 instances (Processing count may vary as records get modified before BIX extraction)
2019-05-21 10:38:38,761 [ PegaRULES-Batch-4] [ ] [ ABC:01.01.01] ( internal.access.ExtractImpl) INFO mpg - BIX Version : 8.1.3
2019-05-21 10:38:38,775 [ PegaRULES-Batch-4] [ ] [ ABC:01.01.01] ( internal.access.ExtractImpl) ERROR mpg - abc.abcexception: table doesn't exist in target Database: PegaBixRepo
2019-05-21 10:38:38,790 [ PegaRULES-Batch-4] [ ] [ ABC:01.01.01] ( internal.access.ExtractImpl) INFO mpg - PAL Statistics for BIX Extract run :

Please help

***Edited by Moderator Marissa to update platform capability tags****

Correct Answer
May 24, 2019 - 4:06am

Hi All,

Was able to resolve this by adding the schema as "currentSchema=abc" in the postgreSQL Connection jdbc url within Pega database setting.

Thank you all for suggestion given.

 Regards,

Sonal

 

 

Comments

Keep up to date on this post and subscribe to comments

Pega
May 21, 2019 - 2:58pm

Hi Sonal,

As the extraction output is to database,Did you generate the schema DDL which contains the query to create table in database.

The error message says that target table database doesn't exists in the database. 

IF not, please generate the DDL and create the table in database. After that try executing the extract rule and verify the records in database.

Please let us know if that works.

Regards,

Waseem Khan

September 13, 2019 - 1:41am
Response to khanw2

i have created like ddl like u said and tried running extract rule but wtill getting same error as table is not there in target database

Mod
September 13, 2019 - 10:19am
Response to MounikaRathnamS3443

Hello,

We see that you have another post for this, which hs much activity! Extract Rule is not Working

Lochana | Community Moderator | Pegasystems Inc.

Pega
May 22, 2019 - 2:31am

You will get this error when your target database does't not contain the suitable table.So before running the extract please check the checkbox to generate the create table query so that it will give you the query . Run the same query in the target database and perform the extract operations

 

 

 

May 22, 2019 - 3:08am

Thank you for the reply.

Running the table schema to create the table was our first step. only after this we ran the rule to perform the extract. Still same error.

Tried this for one more class now:

Please suggest any other option to try out

 

Pega
May 22, 2019 - 3:29am
Response to SonalN00

Hi Sonal,

Is the target database table part of PegaRules and PegaData schema or it is  created as part of separate schema. Can you please provide us the database table definition along with screen shots of Extract rule?

Also please enable the debug logs for below class and provide us the log file.

com.pega.pegarules.data.internal.access.ExtractImpl

Regards,

May 23, 2019 - 4:21am

Hi

target database is a seperate database with a seperate schema. it is not part of pega rules or pega data. ports are open between page app and the DB. we have tested out the connectivity.

Attached screenshots of ruleset and Db setup in Pega

Attached logs  in debug mode

Pega
May 22, 2019 - 4:31am
Response to SonalN00

Please create the target table in the default schema of the external database. Dont create it in any separate schema as we dont have any option to specify the schema name here

So Please create the table in the default schema.

What is the external database type?

May 22, 2019 - 6:15am

the external database type is postgreSQL

we have BIX on pega 7.2 where we push extracts to microsoft SQL server. Here we push data to separate schema and it works.

why not in postgreSQL?

May 24, 2019 - 4:06am

Hi All,

Was able to resolve this by adding the schema as "currentSchema=abc" in the postgreSQL Connection jdbc url within Pega database setting.

Thank you all for suggestion given.

 Regards,

Sonal

 

 

Mod
May 24, 2019 - 8:59am
Response to SonalN00

Thank you for updating the solution! We have marked this post as Answered.

Lochana | Community Moderator | Pegasystems Inc.