Blocking Transaction

I have a 3 simple packages get called from master package. First package populates time dimension (stored proc), second one populates transaction type dimension(stored proc) and the final one populates date dimension.

I set the TransactionOption = Required in the Master package, every thing else (package & component) set TransactionOption = Supported.

I have been testing transactions, basically I made time and transaction type dimension to fail and the package did roll back. I am stuck in the date dimension.

Within Date dimension I got a stored procedure which populates calendar date attributes into Wrk_Date table. Then I have a data flow task which reads from thats working table, but it cant access it. I tried running SP_WHO2 command, and the status is SUSPENDED, being blocked by id -2.

I saw someone had similar problem and I did read Ash's comments. I did try to change the isolation level, didnt help.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=74372&SiteID=1

Any thoughts please?

Thanks

Sutha

Sutha,

I had enormous problems with this and eventually just dropped the use of distributed transactions altogether. In some cases it simply wouldn't work because of the way DTC holds onto resources. Since then I have used checkpoint files and it works just fine.

-Jamie

|||

Jamie

Thanks for the infor, but it is annoying. Do you know this is going to be fixed at any point ?

Client is not happy having a checkpoint. They want to rollback the whole dimension load. For example if we have got 6 dimensions and 5 of them loaded fine and 6th one failed, then they want to rollback the whole lot. What would be the solution in that scenario please, if we cant use transactionoption correctly?

Thanks

Sutha

|||

I don't think its a case of it being fixed - its just "the way it is". DTC isn't doing anything wrong - its doing exactly what you've told it to i.e. Maintaining a lock on a table because of a running transaction.

Its a difficult one to broach with the client, I can see that. Maybe you could restructure your package so that the locks don't occur.

-Jamie

|||

Jamie

Thanks. I was going through step by step and identified the reason for locks. During step 2, if date table exist in stage database it TRUNCATES the table else it creates the table. Truncate statement seems to hold the lock and it is not releasing it further down the line. I have managed to get the rollback to work after removing truncate.

Thanks

Sutha

blank pages

I have two tables in my report. The second table spans two pages, because of
this, in the pdf output, the first table has blank pages after each page.
Anyone could help me on this?
Thanks
AngeloI solved this myself by putting the second table into a list
"Mathi" wrote:
> I have two tables in my report. The second table spans two pages, because of
> this, in the pdf output, the first table has blank pages after each page.
> Anyone could help me on this?
> Thanks
> Angelo

blank page in pdf report

When I export my report to PDF, I get a blank page that shows up. The
header and footer are on the second page, but the body is blank. There
isn't enough data for a second page. Why is one being created? Any ideas?Most likely, something in your footer is touching one or more of your
margins. Make sure everything is inside the margins and you should be
good.

Blank Page

The report has just one page of information...but a blank second page is
printed with the page header and footer...
Any advise ?make sure you dont have "new page after" checked in the properties and also
check to make sure the dotted back ground is the same size as your table. I
am drawing a blank so all I can think of is dotted background. I know there
is another word for it. LOL!!! Its the area in the layout view behind your
table or graphs. Just resize it by dragging the edge to make it the same
size as your table.
"Ranga" <Ranga@.discussions.microsoft.com> wrote in message
news:60E22DEE-A30F-4142-94AB-376E8B730AC7@.microsoft.com...
> The report has just one page of information...but a blank second page is
> printed with the page header and footer...
> Any advise ?

Blank line in Group using RS2000

I have a table with 3 groups before the detail level. In the second
level I use a filter because one of the group only have information in
the top group. The problem is that when I make a deploy with the
hidden camp - true is show well but when I put false in the Hidden
it's shows a blank line before the other group. How can I solve this
problem?On Apr 2, 9:52 am, pedro.geral...@.netvisao.pt wrote:
> I have a table with 3 groups before the detail level. In the second
> level I use a filter because one of the group only have information in
> the top group. The problem is that when I make a deploy with the
> hidden camp - true is show well but when I put false in the Hidden
> it's shows a blank line before the other group. How can I solve this
> problem?
I'm assuming you already have checked 'Fit table on one page if
possible' as part of the Table control properties. Which may only
shrink the overall table a little bit. Otherwise, as far as I know,
there's not much else that you can do to eliminate the empty row. That
said, you should be able to control this better as part of your stored
procedure or query that is sourcing the report. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant