You’re offline. This is a read only version of the page.
I am having an issue with creating or opening new columns.
I get an error message "problem with data provider".
I am able to create reports and view, create and view companies, but not the columns.
This database with converted from sl 2011 and frx 6.7 sp 12. Single currency database.
All data is validated via MR with no issues outstanding.
Mr version 12.1400145
Sl 2015 9.61.30423.01
Thanks for your assistance!
*This post is locked for comments
You say all data is validated via MR with no issues outstanding. Did you run the diagnostic script found in the below KB article? If not, run that and if you get results then follow the steps in the article.
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-US;2931999
If you don’t get any results from this diagnostic script then in other cases I found the issue was with a blank CuryID somewhere which I would think the diagnostic script should find these but if it doesn’t then run the below scripts and verify the CuryID’s look correct.
Run on application database
select BaseCuryID, * from Ledger
select CuryId, * from Currncy
select BaseCuryId, * from GLSetup
select * from GLTran where CuryId = ''
select * from GLTran where BaseCuryID = ''
select * from AcctHist where CuryId = ''
select * from CuryAcct where BaseCuryID = ''
select * from CuryAcct where CuryId = ''
Run on system database
select BaseCuryID, * from Company
You could also go to the Configuration console and run the Run ERP data validation and then go to the Data Mart Integration logs and take a look at errors that may be there.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (