Home » Support » Telligent Analytics » Bugs & Issues » Telligent.Tasks.Service.exe Error: 0 : Exception: Invalid object name 'csr_UserData'.

Telligent.Tasks.Service.exe Error: 0 : Exception: Invalid object name 'csr_UserData'.

Open Support Ticket

Call Support:
Direct: (214) 420-1337
Toll Free: (877) 522-6334

Monday through Friday
8 a.m. to 6 p.m. Central (GMT-6)

Join our Community
Details
  • 6 Replies
  • 3 Subscribers
  • Postedover 2 years ago
Options

Telligent.Tasks.Service.exe Error: 0 : Exception: Invalid object name 'csr_UserData'.

This question is answered
monkeyboy32
Posted by
on Tue, Jun 29 2010 6:10 PM

Hi I have enabled tracing on my Harvest 2 app. Most of the reports are ok but user data like Log in data is not being populated.

I get the following error in the trace log:

Telligent.Tasks.Service.exe Error: 0 : Exception: Invalid object name 'csr_UserData'.

So - this looks like the related error but I just don't know why it errors - there is a csr_UserData table (a + b) for each of my sites. And - the connection string is the same for all tasks. 

Any ideas why this isn't working?

Thanks
Verified Answer
  • monkeyboy32
    Posted by
    on Tue, Jun 29 2010 9:27 PM

    Anyone? If you have ANY idea about this - please let me know. I can't describe how important it is to get his fixed.

    Thanks
  • JanaCarter [Telligent]
    Posted by
    on Tue, Aug 3 2010 11:31 PM

    Sorry for the delay, was this resolved for you?
  • monkeyboy32
    Posted by
    on Tue, Aug 3 2010 11:45 PM

    Nope. I kind of gave up on it - I tried every permutation of task string I could think of but it still didn't work.

    I need to remind myself of the details of this. I'll get back to you as soon as I can as I still need this fixing.

    Thanks for getting back to me btw.
  • Alex Crome
    Posted by
    on Wed, Aug 4 2010 11:12 AM

    Did you use a schema name other than "community"?  If so you'll need to update the schemaName used by the connection for each task in the taskstrings.config file.
  • monkeyboy32
    Posted by
    on Wed, Aug 4 2010 11:17 AM

    Alex - yes I did use a schema name other than community and I updated the schema name as you said. Most of the reports are working, just a few aren't pulling in any data - namely user log ins.

    Oddly enough I did get it working but, when it did work, it only worked for a while - as if the task ran and then, a bit later the data was overwritten.
  • JanaCarter [Telligent]
    Posted by
    on Fri, Dec 3 2010 10:25 PM
    Verified Answer
    Verified by

    Did you enable task logging? If yes, can you provide the HRSTrace log file (or review it for task errors)? Are the reports still not working? Can you describe which reports/tasks are not working and exactly what you are seeing?

    Thank you

    Jana Carter

    Telligent Program Manager
All Replies
  • monkeyboy32
    Posted by
    on Tue, Jun 29 2010 9:27 PM

    Anyone? If you have ANY idea about this - please let me know. I can't describe how important it is to get his fixed.

    Thanks
  • JanaCarter [Telligent]
    Posted by
    on Tue, Aug 3 2010 11:31 PM

    Sorry for the delay, was this resolved for you?
  • monkeyboy32
    Posted by
    on Tue, Aug 3 2010 11:45 PM

    Nope. I kind of gave up on it - I tried every permutation of task string I could think of but it still didn't work.

    I need to remind myself of the details of this. I'll get back to you as soon as I can as I still need this fixing.

    Thanks for getting back to me btw.
  • Alex Crome
    Posted by
    on Wed, Aug 4 2010 11:12 AM

    Did you use a schema name other than "community"?  If so you'll need to update the schemaName used by the connection for each task in the taskstrings.config file.
  • monkeyboy32
    Posted by
    on Wed, Aug 4 2010 11:17 AM

    Alex - yes I did use a schema name other than community and I updated the schema name as you said. Most of the reports are working, just a few aren't pulling in any data - namely user log ins.

    Oddly enough I did get it working but, when it did work, it only worked for a while - as if the task ran and then, a bit later the data was overwritten.
  • JanaCarter [Telligent]
    Posted by
    on Fri, Dec 3 2010 10:25 PM
    Verified Answer
    Verified by

    Did you enable task logging? If yes, can you provide the HRSTrace log file (or review it for task errors)? Are the reports still not working? Can you describe which reports/tasks are not working and exactly what you are seeing?

    Thank you

    Jana Carter

    Telligent Program Manager