Hi,
In the server job, I am using a Sybase table (which is read only) as the source table. While running the job I am getting the following warning:
"SRC_CMC_SBSB_SUBSC: Sybase Server warning 3906 (severity 16): Attempt to BEGIN TRANSACTION in database 'fidelis_311' failed because database is READ ONLY"
My question is: If the source database is read only cant we select the required rows and populate another database(which is not read only)?
Thanx
Subra
Issue with source tables which are read only.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Fri Oct 15, 2004 11:53 pm
- Location: Bangalore, India
- Contact:
It shouldn't be an issue.
Is there a way to not have it think it's transactional work? For example, in the OCI stages you can change the Transaction Isolation property from 'Read Commited' to 'Read-Only' - is there an equivalent in whatever stage you are using?
Is there a way to not have it think it's transactional work? For example, in the OCI stages you can change the Transaction Isolation property from 'Read Commited' to 'Read-Only' - is there an equivalent in whatever stage you are using?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 22
- Joined: Fri Oct 15, 2004 11:53 pm
- Location: Bangalore, India
- Contact:
subramanya,
do you have the option to go through an ODBC stage to see if that works differently, and if it does work is it fast enough for your purposes (as a workaround)
do you have the option to go through an ODBC stage to see if that works differently, and if it does work is it fast enough for your purposes (as a workaround)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 22
- Joined: Fri Oct 15, 2004 11:53 pm
- Location: Bangalore, India
- Contact:
Subramaya,
I think it is time to submit a call to Ascential - sounds like an easy issue to reproduce. Please post the response/resolution here as well, since I for one am very interested and I am sure that this scenario will pop up again.
I think it is time to submit a call to Ascential - sounds like an easy issue to reproduce. Please post the response/resolution here as well, since I for one am very interested and I am sure that this scenario will pop up again.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>