The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
mithun_laha
2 years agoNew Contributor III
How to migrate Application Table from one application to another application.
I am getting error "Unable to access database table 'ABC'. Database table 'ABC' does not exist". If we create a table with extensibility. Does it solve the problem?
mithun_laha - How did you create the table? Using the Table Data Manager? or Using BR.
1.Typically, if you use the CAT (Cloud Admin Tool) it will copy all the tables from one application to another.
2. If it is cloud you can create a support ticket to migrate.
3. Export and Import would also work.
Yes you can export and import using TDM. It will be exported as XML and you can upload the same.
7 Replies
- KrishnaValued Contributor
mithun_laha - How did you create the table? Using the Table Data Manager? or Using BR.
1.Typically, if you use the CAT (Cloud Admin Tool) it will copy all the tables from one application to another.
2. If it is cloud you can create a support ticket to migrate.
3. Export and Import would also work.
- mithun_lahaNew Contributor III
Hi Krishna - I did manual migrate from one environment to another. Ca you explain me Export and Import process? Is it using Table Data Manager?
- KrishnaValued Contributor
Yes you can export and import using TDM. It will be exported as XML and you can upload the same.
- BrooksNew Contributor III
I am having similar problems with XFT tables that were apparently created when implementing Guided Reporting. I need to migrate them from our development application to our test application, but get an error "Only and XFC table or view can be dowloaded. Guided Reporting won't work without these tables (for instance, XFT_GRT_ReportColumnSets). How do I migrate these tables?
- BernardoNNew Contributor II
Hey, did you manage to solve your issue ? We have the same problem, we developed guided reporting on a DEV app and now we can't find a way to migrate it to our Prod app. It looks like the only way to do it is start from scratch.
Thanks
- BrooksNew Contributor III
I did solve it. The solution is you have to put in a ticket through ServiceNow and specify the tables to copy. You may need to escalate it as some techs will tell you they can't do just tables, only the entire application. That is not true.
Related Content
- 2 years ago
- 4 years ago
- 3 years ago
- 5 months ago