5

I have been checking the configurations for content delivery but keep getting this error when I am loading the site. It appears to be telling me it is related to a SQL error but I double checked the web.config and xmls files in config folders and they seem to be straight.

Any ideas how to troubleshoot this one?

[AmbientDataException: SQL exception] Codemesh.JuggerNET.NTypeValue.Throw(Int64 inst) +514 Codemesh.JuggerNET.JavaClass.ThrowTypedException(Int64 inst) +1243 Codemesh.JuggerNET.JavaMethod.CallObject(JavaProxy jpo, JavaMethodArguments args) +915 Com.Tridion.Ambientdata.EngineFactory.NewEngine(AmbientDataConfig ambientDataConfig) +159 Tridion.ContentDelivery.AmbientData.HttpModule.InitializeAmbientFramework() +226 Tridion.ContentDelivery.AmbientData.HttpModule.Init(HttpApplication application) +90 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +575 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +352 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +407 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +375

[HttpException (0x80004005): SQL exception] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +11702064 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +141 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +4870277

Improve this question
2
  • Try setting the application pool to enable 32 bit and also .net 4.0.
    – robrtc
    Commented May 5, 2013 at 15:42
  • @fsnova did you ever come to a solution for your issue, or is this question still open? Perhaps you can provide an update (either by editing the question and supplying more information or posting an answer with the solution and accepting that)?
    – Bart Koopman
    Commented May 15, 2013 at 11:59

2 Answers 2

Reset to default
4

90% of the time my SQL Errors are because I forgot to drop the 3rd party jar "sqljdbc4.jar" into my application /bin/lib directory, i'd first confirm you have this.

Failing that you can configure content delivery logging via your logback.xml file, this should give you a lot more information as what's going on in your app and the cause of the failure.

If you still can't solve it after confirming the jar and consulting the logs, perhaps update your question with your log file?

Improve this answer
3
  • I have double checked the sqljdbc4.jar was in bin/lib folder. I also downloaded the updated version sqljdbc_4.0.2206.100_enu to ensure the file is up to date and not corrupted.
    – fsnova
    Commented May 3, 2013 at 15:51
  • I checked the logs in C:\tridion\log and only sync_audiencemanager log was updated. There is an error still related to SQLException.
    – fsnova
    Commented May 3, 2013 at 15:53
  • 2013-05-03 16:45:17,109 ERROR Contact - Unable to instantiate contact object java.sql.SQLException: No Data Access Object for AudienceManagerProfile at com.tridion.marketingsolution.profile.ExtendedDetails.loadExtendedDetailsTemplate(ExtendedDetails.java:51) ~[oe_profile.jar:na]
    – fsnova
    Commented May 3, 2013 at 15:57
2

Generally this error comes because of following few reasons:

  1. SQLJDBC4.jar is missing or corrupted
  2. The JRE Version is between - 1.6.0.25 to 1.6.0.30 - Ensure you JRE version does not lie among any of these versions - This is a known issue with Third Party API
  3. You are checking for configs, jar files etc. in a particular Directory but the home directory that is getting loaded is different - Check your event log and ensure that it is getting loaded from the expected directory
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.