web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / MR Data Mart Integrati...
Microsoft Dynamics GP (Archived)

MR Data Mart Integration error: The log for database 'tempdb' is not available.

(1) ShareShare
ReportReport
Posted on by Lou@ACE 447

I am getting these errors from the MR data mart integration every 5 minutes:

Operation: GL Transaction to Fact

Total Message Count: 5

Record ID:

Message:

Count:

Date:

Time:

The log for database 'tempdb' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

5

8/15/2019

5:56 PM

Operation: ExchangeRateProvider to Exchange Rate

Total Message Count: 1

Record ID:

Message:

Count:

Date:

Time:

The log for database 'tempdb' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

1

8/15/2019

5:55 PM

So far I've done the following:

  • Checked the SQL Activity logs - There are no errors relating to tempdb or the data mart.
  • Stopped and Started the SQL Server service to recreate tempdb.  Tempdb recovery is set to Simple so there is no log file.
  • Recreated the MRDataMart DB.
  • Checked the Event Viewer logs and the MR Integration Console logs and did not find these errors.

What can I do to resolve the issue that is causing these messages?  Thanks.

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Something is wrong withe the tempdb database on your server. If you can, reboot your SQL server. If that is not possible stop and start the SQL service. If neither work go into SSMS and let us know the status of the tempdb database. Make sure you have not run out of disk space.

  • Lou@ACE Profile Picture
    Lou@ACE 447 on at

    Thanks Richard. We rebooted the server.  I rebuilt the data mart.  I just reviewed the SQL server with our DBA and found no issues with tempdb.  There are no errors in the activity log.  There is no tempdb log file because the recovery mode is Simple.  There are no errors in the integration log. I think my next step is to run a trace on the DM integration.  

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    There has to be a log file for tempdb. Is it called temp.ldf?

    If you go into SSMS and then System Databases and right click on tempdb -> Properties -> Files scroll to the right to see where this file is kept. You may find that now has several partitions.

  • Lou@ACE Profile Picture
    Lou@ACE 447 on at

    There is a log file.  However, no transaction logs are generated as configured with Simple recovery mode.  That was the case before the notifications began appearing.  Nothing has changed with the setup.  The notifications are coming from the DM Integration, not from SQL Server.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    In SSMS the tempdb database is not marked as offline or read-only is it? Is there anything in your event viewer that may yield a clue? Try running SQL Profiler to see if this shows anything. Also, elevate the domain account being used to run the MR services to sysadmin just see if it is a security issue. Start and stop the services after elevation.

  • Lou@ACE Profile Picture
    Lou@ACE 447 on at

    Nope.  No apparent issues with tempdb.  Nothing in the event viewers.  I already inserted sa for the integration.

    It may come down to running a trace because the notifications reference 2 specific maps in the DM Integration and always the same number of items.  I may need to get into the weeds and pin those down.  I was hoping to avoid that.

    Thanks.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Did this ever work? Are you using the latest version of MR? 'sa' is fine for the integration but what about the service accounts running MR? Do they have the sysadmin role? Are they in the local admin group on this server? I am wondering if you are fighting some security issue.

  • Lou@ACE Profile Picture
    Lou@ACE 447 on at

    It worked like clock work up until Tuesday morning which is when the notifications started.  Security was fine then but I will check on the service account for MR in case it was affected by a group policy roll down.  It's unlikely but we'll check that off.  I doubt that a security issue would cause issues on these two specific maps within the integration.  I'm more inclined to think it may be corrupt or out of range data that needs to be tracked down.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Do you have more than one company in MR? Perhaps turning off MR for all but one company and then adding then back one by one may help isolate the problem. You may want to rebuild the DM each time you add a company.

  • Lou@ACE Profile Picture
    Lou@ACE 447 on at

    We only have one company.  I appreciate the suggestions.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans