- Posts: 290
- Thank you received: 1
ETL error - "Row cannot be located ..."
8 years 5 months ago #12747
by orlandoc
ETL error - "Row cannot be located ..." was created by orlandoc
Please Log in or Create an account to join the conversation.
8 years 5 months ago #12748
by admin
Mike
ETL Architect
Replied by admin on topic ETL error - "Row cannot be located ..."
It is been a while since I have seen this error message
There are a lot of information in the internet about it
www.google.com/search?q=row+cannot+be+lo...Ly8gegJ&ved=0CBEQvwU
It might happend if 2 different users try to update same record at the same time.
We will of course try to reproduce the problem here
There are a lot of information in the internet about it
www.google.com/search?q=row+cannot+be+lo...Ly8gegJ&ved=0CBEQvwU
It might happend if 2 different users try to update same record at the same time.
We will of course try to reproduce the problem here
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
8 years 5 months ago #12749
by orlandoc
Replied by orlandoc on topic ETL error - "Row cannot be located ..."
Just to let you know. I ran this ETL package manually and no other instances of the same package or user.
This appeared twice today after several runs of this package (every 2 mins).
Our database is SQL Server 2008 R2.
Since you mentioned "might happened if 2 different users try to update.." - is this kind of error related to a "application" logic of the package or the ETL way of accessing the database?
As you can see from the screen shot, this error occurred during copying of tif file/s from one place to another. (loop thru image node to copy tif image node).
Please explain any possible scenarios that ETL might get this kind of error.
This appeared twice today after several runs of this package (every 2 mins).
Our database is SQL Server 2008 R2.
Since you mentioned "might happened if 2 different users try to update.." - is this kind of error related to a "application" logic of the package or the ETL way of accessing the database?
As you can see from the screen shot, this error occurred during copying of tif file/s from one place to another. (loop thru image node to copy tif image node).
Please explain any possible scenarios that ETL might get this kind of error.
Please Log in or Create an account to join the conversation.
8 years 5 months ago #12750
by orlandoc
Replied by orlandoc on topic ETL error - "Row cannot be located ..."
we are thinking of indexing our ETL Repository database. Please advise.
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 5 months ago #12751
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic ETL error - "Row cannot be located ..."
"We are thinking of indexing our ETL Repository database. Please advise."
This might be related, all indexes are created for you when you run repository creation scripts.
We are in process of restoring source for version 5.8.0.6 from SVN.
It is very time consuming operation.
Once we are able to build version 5.8.0.6 we will run series of tests in order to try to reproduce the problem
This might be related, all indexes are created for you when you run repository creation scripts.
We are in process of restoring source for version 5.8.0.6 from SVN.
It is very time consuming operation.
Once we are able to build version 5.8.0.6 we will run series of tests in order to try to reproduce the problem
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.
8 years 5 months ago #12752
by orlandoc
Replied by orlandoc on topic ETL error - "Row cannot be located ..."
I provided you our ETL repository database (ETLRepositoryDB) before - that one still in version 5.8.0.6. You can use that for testing if you want to.
Please Log in or Create an account to join the conversation.