Notifications
Announcements
No record found.
While trying to open the HITB reset tool, I get a
"There was a problem creating the tables, please contact support"
Google turns up nothing
(No, I haven't contacted support)
*This post is locked for comments
Are you logged in as 'sa' when you initialize this tool?
Hi Carl,
It sounds to me like you have a security issue with the system trying to create the new tables and/or stored procedures.
I would check that the user you are running it under has appropriate rights to the GP database.
Hope this helps,
Adam
I ran this as SA
Was there a 'More Info' button to at least give us a clue as to what the problem is? I do not know if the scripts that run can create tables that already exist. We need to find out what the real problem is. Can you try running SQL Profiler while you attempt to initialize the HITB Reset tool?
Nope, that was it. I'll run profiler now and see what I can see
Here's a link to the profiler output
http://mars.sscorp.com/profiler.trc
(do a right click, save link as)
What version of SQL are you using?
2012
Unfortunately nothing unusual is in this trace file. It is using the DYNGRP. I would start by checking the mapping of the DYNGRP. It needs db_owner and public on the DYNAMICS and company databases.
You might also check the windows event log to see if it gives you additional error details.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
mtabor 1
Victoria Yudin 1
