View Issue Details

IDProjectCategoryView StatusLast Update
0002246SymmetricDSBugpublic2019-04-23 16:57
Reporternatarajan Assigned Toadmin  
Priorityurgent 
Status closedResolutionwon't fix 
Product Version3.7.11 
Summary0002246: dbexport is not considering the value mentioned in schema and catalog parameter
DescriptionI want to export all the tables from one particular schema which is not same mentioned in the prop file. Below option not working, do you know what is the issue? Thanks

dbexport --format=sql --compatible=mysql --engine=corp-000 --schema ctt1
AHI_PMT_HIST --catalog ctt1

Log output will be written to C:\Users\nsunda1\Desktop\jm\MySQL\symmetric-server
-3.7.11\symmetric-server-3.7.11/logs/symmetric.log
[] - AbstractCommandLauncher - Option: name=format, value={sql}
[] - AbstractCommandLauncher - Option: name=compatible, value={mysql}
[] - AbstractCommandLauncher - Option: name=engine, value={corp-000}
[] - AbstractCommandLauncher - Option: name=schema, value={ctt1}
[] - AbstractCommandLauncher - Option: name=catalog, value={ctt1}
[] - JdbcDatabasePlatformFactory - Detected database 'Oracle', version '10', pro
tocol 'oracle'
[] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpm
ind.db.platform.oracle.OracleDatabasePlatform
-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
java.lang.RuntimeException: Cannot find table AHI_PMT_HIST in catalog ctt1 and s
chema ctt1
        at org.jumpmind.symmetric.io.data.DbExport.exportTables(DbExport.java:14
5)
        at org.jumpmind.symmetric.DbExportCommand.executeWithOptions(DbExportCom
mand.java:192)
        at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractComman
dLauncher.java:190)
        at org.jumpmind.symmetric.DbExportCommand.main(DbExportCommand.java:75)
-------------------------------------------------------------------------------

C:\Users\nsunda1\Desktop\jm\MySQL\symmetric-server-3.7.11\symmetric-server-3.7.1
1\bin>
TagsNo tags attached.

Activities

admin

2019-04-23 16:57

administrator   ~0001418

Use catalog and/or schema as required by database platform. Oracle expects only schema to be used, while MySQL expects only catalog to be used.

https://www.symmetricds.org/doc/3.7/html/user-guide.html#_catalog_and_schema

Issue History

Date Modified Username Field Change
2015-03-31 16:45 natarajan New Issue
2019-04-23 16:57 admin Assigned To => admin
2019-04-23 16:57 admin Status new => closed
2019-04-23 16:57 admin Resolution open => won't fix
2019-04-23 16:57 admin Note Added: 0001418