.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

lookup: unable to allocate memory for hash table

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
 
Hi, I have been getting an error from a lookup component when I run it from the job agent. However, it works just fine from debug mode. the specific error is 0xC0208247: unable to allocate memory for hash table. I get the same error when I run this not in full-cach but in partial and no cache. Also, the default butter max row and buffer size in package are set to default. Does anyone have any idea.   Jon


View Complete Post


More Related Resource Links

lookup table query

  

we are doing our cms migration. both cms's have their own articleID/contentID, we have a lookup table that contain the article URL and its content id.  Now we want to query that table on every single click to get its respective id. 

How and where i can implement this?



unable to create new table in sql server 2000 enterprise manager on windows7(Operating system)

  
i have successfuly installed sql server 2000 on windows7 and i am able to browse all the tables and edit aswell(on enterprise manager) but i have a problem while creating new tables it says ' MMC has detected an error in a snap-in' and provides options to either continue with the error or send a report to microsoft ,   Please help regarding this compatibility issue   Thanks in advance !

Unable to load data into a LookUp column in sharepoint using sharepoint destination

  
I have loaded details of a customer on a list and was able to load the data with out any problem using sharepoint list destination. We have a lookup column called customerid looking at customer list  . This lookup column is in another list, called Customer Main, so I am trying to load additional data for customer in this customer Main  list which contains a lookup column called customerID. I was not able to load data into this cutsomerid, whereas rest of the data is coming into sharepoint with out any problem. How should I load data into a lookup column. Thanks  

how to allocate memory for a dedicated distributor server

  
Hi all, What is the larget memory consumer in a dedicated distributor server? sql server or the Agent? do i need to grant the 'lock page in memory' permission to sql server account in distributor server(This is a 64 bit box with 32GB memory)? ?dba????(???),???? stswordman#hotmail.com

Allocate more memory to the database engine

  
I have a computer with 4GB. How can I allocate more than 2GB to SQL Server? The AWE option still doesn't let me allocate more. Thanks.  

Putting lookup tables in memory

  
How is the best way of putting a lookup table in memory for use though my ASP.NET app? Should I do this in the Global.asax's Application_Start event and keep in Session?What are the advantages in taking this approach?

hash table and datatable

  

I want to store the data in temp table, which is best way to use

hash table or datatable.


Looking forward the reply




Unable to create table dynamically in database

  

I am able to create database through script generated by SQL Server 2008 but unable to create tables from generated script. Please indicate if any step is missing.

 

************* Code *******************

 public bool CreateAppTables(string DatabaseName, string ConnectionString)
    {
        string DatabaseScript;
        DatabaseScript = Activity.readTextFile(HttpContext.Current.Server.MapPath(".") + "/functionalscripts/CreateTablesonly.sql");
        DatabaseScript = DatabaseScript.Replace("DatabaseNametoChange", DatabaseName);
      
        return ActionQueryDB(DatabaseScript, ConnectionString);

    }

 public bool ActionQueryDB(string SQLStatement, string ConnectionString)
    {
        //  SqlConnection cn;

        OleDbConnection cn = new OleDbConnection();

        cn.ConnectionString = ConnectionString;
        try
        {
            cn.Open();
            OleDbCommand cmd = new OleDbCommand();
            cmd.CommandText = SQLStatement;
            cmd.Connection = cn;
            cmd.ExecuteNonQuery();
            cn.Close();

            return true;
        }
        catch (Exception ex)
        {

            cn.Close();
            return false;
        }
    }

 

****************** Contents of text file appe

getting ERP transaction timestamp translated to fiscal period and year (the lookup table exists)

  

Not sure if this is correct forum as it's SQL syntax specific.

Putting in new ERP system which does not hold fical period/year stamps in the transaction records, just the datetime timestamp.  There is a GL table which holds the period year and the begin and end dates.

Need to find a code snippet that I could hook into any sql statement so that I could pull the period and year from the GL table. 

Not sure how to code in sql if the timestamp of the txn is less than x but greater than y, give me the corresponding gl period and year.

Any pointers/links would be great. 

Thanks,

Robert

add:  this is sql server 2008, if it matters.


getting ERP transaction timestamp translated to fiscal period and year (the lookup table exists)

  

Not sure if this is correct forum as it's SQL syntax specific.

Putting in new ERP system which does not hold fical period/year stamps in the transaction records, just the datetime timestamp.  There is a GL table which holds the period year and the begin and end dates.

Need to find a code snippet that I could hook into any sql statement so that I could pull the period and year from the GL table. 

Not sure how to code in sql if the timestamp of the txn is less than x but greater than y, give me the corresponding gl period and year.

Any pointers/links would be great. 

Thanks,

Robert

add:  this is sql server 2008, if it matters.


Unable to alter table that is beeing replicated

  
Hello

We are using SQL Server 2008 and transaction replication. I have set up the publication so that it is replicating schema changes but today i discovered that I was unable to add a column to one table that also is an article in the publication. The error I get is this:

Altering [dbo].[Group]
Msg 650, Level 16, State 1, Procedure sp_MSreinit_article, Line 66
You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.

Have anyone any clue of what this can be?

/Henrik

hesta96

Adding exception table to incremental Load with SSIS Lookup task and conditional split

  

Hello,

I have built an incremental load ETL Process to load some flat files with an SSIS Lookup and Conditional Split. I only have one path in the conditional split and that is for New Records.

I have two questions:

1.       For the new records path, I have to check to see if a record exists and I don’t have a single key that is unique, therefore, I have to use a multiple keys to make the record unique.

 

Below is what I have put in the conditional transformation editor for my first output condition:

 

out of memory loading datatable from large oracle table

  

I've created a winform c# application that connects to an oracle database and loads a datatable with all the data in the oracle table then exports it out to a delimited file, which will then get imported to a local mysql database.  This works just fine when the oracle table isn't so large.  However I keep getting an out of memory exception when I populate my datatable with a large oracle table.  I can't manually export data from oracle then manually load to mysql because this has to be seamless to the user.  I'm having difficulties grasping how to solve this problem.  Is there a better solution then what I have to get from oracle to mysql? 


Unable to retrieve Lookup fields or item URL values from Library(Wiki Page Library) item when using

  

Hi,

When I execute, "l["Category"].ToString();" and the field is a lookup field it returns, "Microsoft.SharePoint.Client.FieldLookupValue[]", on the other hand when I execute "l["Description"].ToString();" which is a normal string field I get the string(multiline) value back, any idea what could be going on here? I have tried, static/internal/displayname all with the same result(lol moment,

Repeating Table displaying ID not value from Lookup field

  

Hi

I'm a newbie to Sharepoint and Infopath so apologies if I am making a stupid mistake. I have searched the forums for this but can't find anything which resolves the issue.

 

Basically lets say I have 2 sharepoint lists (A and B). In B I store customer information and in A I create an invoice which has a look field to B to get the customer name. S:

 

List A: Invoice Number, Customer (Lookup to List B), Date, Amount

List B: Customer Name and other details

 

I create a form in Infopath to display all data for a given customer using a dropdown. So I created a drop down with a Datasource linked to List A to display the customer name. Of course this does not display the customer name but the ID. So I create another data source linked to List B which I use to display the customer name but have a value of ID.

 

I create a repeating table from List A to display all the data which changes depending on what is selected in the drop down. The table updates but in the table the customer name dispalys the ID not the customer name. If I try to change the binding I get an error about "repeating fields".

 

Is anyone able to help in simple newbie steps please?

 

Many thanks

A



UTC Offset Lookup Table for different Time Zones with Daylight Saving.

  

Hi,

I am trying to populate a table for on SQL 2008 Server which should have start datetime and end datetime for daylight saving for various world time zones. So that I can lookup if a particular date is between startdate and enddate and get UTC offset.

Something like the following table. Checked this link but not sure if I can use it in anyway for the information I am looking for or need something completely different.

http://msdn.microsoft.com/en-us/library/ms145276%28v=sql.90%29.aspx

I not an SQL expert and finding it really difficult to get solution for this problem which I am facing.

Appreciate help.

 

<

excel pivot table linked to cube, unable to expand/collaps single field

  

I’m re-posting question. I’m using excel pivot table to browse a cube, for example the adventuresworks example. I drag dimension ‘Product Categories’ and ‘Sales Territory’ to Row Labels area, a date dimension to column, and any measure to Values area. Now I only want to expand ‘Europe’ under ‘Bikes’, but the excel  will expand ‘Europe’ under every ‘Product Categories’, is there any way to avoid that? In visual studio it works fine.


The Time Zone
DST Start DST End Offset for UTC
EST 3/13/11 4:00 11/6/11 3:00 240
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend