SaveCustomDataTable Gives Error
I want to load OneStream application data to external database. And there is an existing connection to the target external database. But it gives me below error, could you please help? No idea what i...
Forum Discussion
the second field is the dblocation, not sure what "FDH_DEV" is but this should be "App" for the application server.
I prefer to create the connection for in a using statement (so it is also actively closed when you are done with it):
Using dbConnApp As DbConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)
'do your thing here
end using
CreateApplicationDbConnInfo is used when loading to application database, I want to load to external database. "FDH_DEV" is SIC external database connection.
As for the second db location field, I tried database name too, not working.ðŸ˜
You can also use BRApi.Database.CreateExternalDbConnInfo (assuming a connection to the external database is already configured in your OneStream environment).
For the parameter DBlocation in SaveCustomDataTable you can use Framework, Application or External
Thanks for your suggestion, I tried different values for parameter DBLocation as below
1) It gives error External database 'External' was not found in the application server configuration settings.
2) It gives error Value cannot be null. Parameter name: connection
