sqlexception icurltracker (hard coded paths)

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Wouter 49 posts 76 karma points

Nov 18, 2013 @ 12:03

SqlException: icUrlTracker (hard coded paths)

Hi, please have a look at the code and remove the hardcoded paths! Use Server.MapPath("~/umbraco/myFile.ascx").

[SqlException (0x80131904): Invalid object name 'icUrlTracker'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +388
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +688
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4403
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +82
   System.Data.SqlClient.SqlDataReader.get_MetaData() +135
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6665901
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) +6667768
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +577
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +107
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +288
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +237
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +262
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) +26
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +161

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +361
   InfoCaster.Umbraco.UrlTracker.Repositories.UrlTrackerRepository.HasInvalidEntries(List`1& invalidRowIds) in c:\Users\kipusoep\Documents\GitHub\UrlTracker\Repositories\UrlTrackerRepository.cs:472
   InfoCaster.Umbraco.UrlTracker.UI.UrlTrackerManager.OnInit(EventArgs e) in c:\Users\kipusoep\Documents\GitHub\UrlTracker\UI\UrlTrackerManager.aspx.cs:61
   System.Web.UI.Control.InitRecursive(Control namingContainer) +186
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2098

Copy Link

Stefan Kip 1606 posts 4098 karma points c-trib

Nov 18, 2013 @ 12:07

0

Which hardcoded paths are you talking about??

Copy Link
Wouter 49 posts 76 karma points

Nov 18, 2013 @ 12:12

0

Huh, I just deleted this topic? Anyhow, just ignore that comment. The exception still presists though, it seems the sql table is not created on installation. Is there any way to trigger this?

Copy Link
Stefan Kip 1606 posts 4098 karma points c-trib

Nov 18, 2013 @ 12:14

0

Ah ok :-) No problem.
The table hasn't been created indeed. Seems like a SQL permissions thing (user not db_owner)?
You can create the tabel yourself by running the SQL scripts found on Github manually: https://github.com/kipusoep/UrlTracker/tree/master/SQL

Copy Link
Wouter 49 posts 76 karma points

Nov 18, 2013 @ 12:16

0

Also, the section for the tab is not created in Dashboard.config:
<tab caption="Url Tracker"><control addPanel="true">/umbraco/UrlTracker/InfoCaster.Umbraco.UrlTracker.UI.UrlTrackerManagerWrapper.ascx</control></tab>

I wonder how it get's installed because there is no entrance in the package.config that copies a user-control or anything? Guess it's done in the code?

Copy Link
Wouter 49 posts 76 karma points

Nov 18, 2013 @ 12:19

0

Hi, wow, that's a fast response :) thank you for the sql scripts, It's all working fine now.

Copy Link
Stefan Kip 1606 posts 4098 karma points c-trib

Nov 18, 2013 @ 13:07

0

It's done in code indeed.
You're welcome, I hope you will enjoy the package :-) Could you mark this topic as resolved? Ty!

Copy Link
Greg Berlin 818 posts 634 karma points

Jan 08, 2016 @ 06:01
0
Hey... I have this same problem, however mine was caused by the following:
- I backed up a production database and restored it to my local sql server.
- Pointed umbraco dev site to local sql DB
- error thrown
If i change my local dev environment to point to the production DB from where i took the backup, it works.

I've checked and the table does exist (though it's called cosec.icUrlTracker in both databases)

SO, I have a working site when pointing to the DB on the server, but when i point to the DB on my local SQL server instance (same DB), it fails.

I suspect it's permissions based, however I've set the permissions to the same from what i can tell, and even assigned schemas as per production server.

Any ideas what else could be causing this?

Thanks Greg
Copy Link
Greg Berlin 818 posts 634 karma points

Jan 08, 2016 @ 06:32

0

Okay, so running the SQL create script fixes the issue.... which is weird as the table it creates doesn't exist on the production DB, yet pointing to that DB works on my local. WTF??

Anyway, i'm up and running for now, but I'd love to have a resolution to this before i need to do this restore procedure again.

Copy Link
nickornotto 317 posts 679 karma points

Apr 12, 2018 @ 11:12

0

Hi @Greg, I've got the same problem - after copying my server db to local. Did you find a solution to this? Thanks

Copy Link
Andy Shokry 5 posts 75 karma points

Jun 22, 2020 @ 17:26
0
I was able to fix the backup/restore issue by running this against the database:
```
ALTER SCHEMA dbo TRANSFER oldSchema.[icUrlTracker]
```
Copy Link
is working on a reply...

This forum is in read-only mode while we transition to the new forum.

You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies