I have created an Orchestrazation for biztalk integration.
I am getting following error and orchestrazation is getting suspended.
System.NullReferenceException: Object reference not set to an instance of an object.
Can any one help me with this
We have atleast 5 aggregations. This could be one of the reason. But one interesting thing we are noticing, when we are processing the cube the temp db hogs all the 25GB assigned, why is this?
Folks,
We are facing this typical problem with the cube design. we have the sample design as follows
Fact Table
fact1
-------
contentkey
monthkey
views
Contentdim
-----------
contentkey
Title
Confidentiality
Keyworddim
--------------
Keywordkey
Name
Contentkeyworddim: one to may bridge...
specify the name of database user ('dbo') in the query
For example:
Try below one
SELECT a.surname,
b.model
FROM employee.dbo.details a INNER JOIN vehicles.dbo.companycars b
ON a.regno = b.regno
Nolock Does not issue any shared locks and it do not honor exclusive locks. When this nolock is in effect, it allows to read an uncommitted transaction or a set of pages that are rolled back in the middle of a read.
Muliple select statements can access the same table concurrent if nolock is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.