7.1.2 bfimport is failing "BF_COMPONENT"is an unde
Hello,
I am trying to import all the project from one environment in Buildforge 7.1.1 to another environment in BuildForge 7.1.2 but the bfimport is failing.
If the import process is executed by comand line, the error is the next:
When I execute the import by command line I receive the following errors
D:\Program Files\IBM\BuildForge>bfimport -L -p -I -S -s -c -C -u -T -f -r "C:\Temp\cpImport\DEV_ASM.xml" > C:\Temp\cpImport\DEV_ASM.log
DBD::DB2::db prepare failed: SQL0204N "CHADM.BF_COMPONENT" is an undefined name. SQLSTATE=42704
DBD::DB2::st execute failed: SQL0204N "CHADM.BF_MESSAGES" is an undefined name. SQLSTATE=42704
I have checked the schema (with bfschema -l) of the destination environment and I can see the presence of the table bf_component and bf_message in the listing.
Do you have any idea about the origin of the problem ?
Many thanks in advance for your answer.
Regards,
Armand
I am trying to import all the project from one environment in Buildforge 7.1.1 to another environment in BuildForge 7.1.2 but the bfimport is failing.
If the import process is executed by comand line, the error is the next:
When I execute the import by command line I receive the following errors
D:\Program Files\IBM\BuildForge>bfimport -L -p -I -S -s -c -C -u -T -f -r "C:\Temp\cpImport\DEV_ASM.xml" > C:\Temp\cpImport\DEV_ASM.log
DBD::DB2::db prepare failed: SQL0204N "CHADM.BF_COMPONENT" is an undefined name. SQLSTATE=42704
DBD::DB2::st execute failed: SQL0204N "CHADM.BF_MESSAGES" is an undefined name. SQLSTATE=42704
I have checked the schema (with bfschema -l) of the destination environment and I can see the presence of the table bf_component and bf_message in the listing.
Do you have any idea about the origin of the problem ?
Many thanks in advance for your answer.
Regards,
Armand
2 answers
There seem to be a lot of things wrong here.
This will only list the contents of the XML file (-L overrides everything else.)
bfschema -l only lists the contents of the schema XML file, not the contents of the acutal database.
The error messages you are getting assert that you do not have BF_COMPONENT and BF_MESSAGES tables in your database. You should check that using the DB2 Control Center.
D:\Program Files\IBM\BuildForge>bfimport -L -p -I -S -s -c -C -u -T -f -r "C:\Temp\cpImport\DEV_ASM.xml" > C:\Temp\cpImport\DEV_ASM.log
This will only list the contents of the XML file (-L overrides everything else.)
I have checked the schema (with bfschema -l) of the destination environment and I can see the presence of the table bf_component and bf_message in the listing.
bfschema -l only lists the contents of the schema XML file, not the contents of the acutal database.
The error messages you are getting assert that you do not have BF_COMPONENT and BF_MESSAGES tables in your database. You should check that using the DB2 Control Center.
There seem to be a lot of things wrong here.
D:\Program Files\IBM\BuildForge>bfimport -L -p -I -S -s -c -C -u -T -f -r "C:\Temp\cpImport\DEV_ASM.xml" > C:\Temp\cpImport\DEV_ASM.log
This will only list the contents of the XML file (-L overrides everything else.)
I have checked the schema (with bfschema -l) of the destination environment and I can see the presence of the table bf_component and bf_message in the listing.
bfschema -l only lists the contents of the schema XML file, not the contents of the acutal database.
The error messages you are getting assert that you do not have BF_COMPONENT and BF_MESSAGES tables in your database. You should check that using the DB2 Control Center.
Thanks for your help. The tables where not present in the database. I have fixed the problem by generating again the tables.
Best Regards,
Armand