Hi,
how can someone build user defined functions and procedures in c# using Microsoft Visual Studio 2005 Professional Edition (SP1) and compile them for the IA64 platform (Itanium)?
There is no target platform option "Itanium" in the project's properties (in the Build tab).
I am using the Oracle OLEDB provider in part of my SSIS package:
OraOLEDB.Oracle.1
Our DTSX package is running fine on a x86 machine. I am getting the following error when I run it on our IA64 machine:
version 1.0.0.0, stamp 45e84da3, faulting module oracore10.dll, version 10.2.0.1, stamp 435841b0, debug? 0, fault address 0x00000000001e4910.
Has anyone had any issues with the OraOLEDB.Oracle.1 provider in SSIS on IA64 machines?
Also, on a side note has anyone used an IA64 Jet driver as well? I can't seem to find one on the net.
Thanks,
Brian
I am replacing a production database. Initially I sized a Quad 2.8GHz with 8 GB of Ram. I will be running Windows 2003 EnterpriseServer with Sql Server 2000 Enterprise. I was wondering what kind ofperformance I would (better/worse) get from a Dual 1.5 GHz Itaniumwith 8 GB of Ram running the 64 bit versions of Windows 2003 and SqlServer. Hardware cost are pretty comparable, but I could save on SqlServer licenses. Anyone that has some experience or has anydocumentation that could compare the amount of processing powerbetween the two architectures. Example: A 1.5 Itanium is comparableto 2 2.4 Zeons. Any help would be appreciated.
View 1 Replies View RelatedI'm looking for some clarification.
We need to pull data from our DB2 system to our Itanium SQL Server.
Is this simply a matter of setting up the 64-bit DB2 Connect drivers on the Itanium box with the exact same DSN name used on ther 32-bit box used to define and deploy the SSIS package?
Has any one done this, yet? If so, is there anything that we need to look our for?
Thanks,
- Paul
I have an SSIS job that is exiting with an error on a 64 bit Itanium SQL 2005 sp1. It has three parallel streams of execution. I've been running my tests using dtexec with verbose output being sent to a file.
2 of the streams execute several truncates and then are followed by 4 steps that load data from a SQL 2000 server to a SQL 2005 server. One of the job streams sources it's data using a SQL Server username/password while the other sources it's data using integrated security. Both streams use integrated security for the destinations.
The third job truncates 2 tables and then loads those two tables from an Oracle database. The oracle connections use a username/password in a connection string in a configuration database while the SQL side of the connection uses integrated security.
I've validated security is working, I've validated the drivers for Oracle are working in 64 bit mode and 32 bit mode for the connection strings I'm using, and security for the package. To top it off, this package runs to completion in 32bit mode under the same credentials.
The only warning messages I get running in verbose mode are the following warnings from the Oracle connection:
OnWarning,311-SQL-01,CHARLOTTE!lcharlton,Import Employee Locator,{EE2C1DB7-A767-4AE6-81F4-6FAE6BFBD2CF},{DF323107-1ABD-4790-A318-B046862C6F58},10/19/2006 2:24:55 PM,10/19/2006 2:24:55 PM,-2145378202,0x,Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
Any insights into how to troubleshoot this or possible additional steps I could take are warmly welcomed.
LarryC
While SQL Server installed into our clustered environment with no significant problems Service Pack 2 will not install with the Error "Unable to install Windows Installer MSP file" during the update to the Database Services.
Subsequently, Integration Services, Native Client and Backwards Compatibilty also fail to upgrade due to suspended installs.
Searching for this returns a number of articles none of which match what we are seeing, including:-
http://support.microsoft.com/kb/918357 indicates this is a problem with the Setup Support Files.
This is not the case and the Setup Support files are updated. Also the permissions are correct on the folder and files mentioned,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=448685&SiteID=1 also point to a problem when installing the Setup Support Files. Our install gets past this but fails on the database engine then sets up a chain of suspended installs.
Other finds indicate there may be another msi running, again this is not the case and the server has been failed over and rebooted a number of times.
At the moment we are sitting at RTM having rebuilt the machine completely but would like to move forward onto SP2. Has anyone come across this and provide any further information or resolution?
We have successfully deployed SP2 onto a number of other servers cover both clustered and non clustered, 32 bit and X64 installations with no problems and now wondering if the problem is Itanium edition specific.
extract from the install log from the failed install. The logs mentioned in this log do not exist post install, in fact the Hotfix folder is not there.
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 IA64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 IA64 ENTERPRISE
Integration Services ENU RTM 9.00.1399.00 IA64 ENTERPRISE
SQL Server Native Client ENU 9.00.1399.06 IA64
Client Components ENU RTM 9.00.1399.06 IA64 ENTERPRISE
MSXML 6.0 Parser ENU 6.00.3883.8 IA64
SQLXML4 ENU 9.00.1399.06 IA64
Backward Compatibility ENU 8.05.1054 IA64
Microsoft SQL Server VSS Writer ENU 9.00.1399.06 IA64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 1601
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 1601
Error Description : MSP Error: 1704 An installation for Microsoft SQL Server 2005 (64-bit) is currently suspended. You must undo the changes made by that installation to continue. Do you want to undo those changes?
Hello,
I'm having an odd issue trying to run an SSIS package on a 64 Bit SQL 2005 SP2 (build 3042) Windows 2003 SP2 64 bit AMD Cluster. I have to use the dtexec cmd line utility from SQL Server Agent because I need to connect to an Access database. When running the package from dtexec, it doesn't seem to be able to load the package, i keep getting this error:
Executed as user: USSI-CORPsql02admin. ...00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:56:00 PM Error: 2008-03-03 13:56:01.28 Code: 0xC0010018 Source: {DFBF51D9-DF81-41B9-9370-9DFC68E28FBA} Description: Error loading value "<DTSropertyExpression xmlnsTS="www.microsoft.com/SqlServer/Dts" DTS:Name="Subject">@[User::vString]</DTSropertyExpression>" from node "DTSropertyExpression". End Error Error: 2008-03-03 13:56:01.28 Code: 0xC0010018 Source: {DFBF51D9-DF81-41B9-9370-9DFC68E28FBA} Description: Error loading a task. The contact information for the task is "Send Mail Task; Microsoft Corporation; Microsoft SQL Server v9; ? 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. End Error Error: 2008-03-03 13:56:01.53 Code: 0xC001000E Source: TestMsgBox Description: The connection... Process Exit Code 1. The step failed.
The @[User::vString is a string variable in the package, and this particular package is actually just using the SendMail task without using an Access DB, as i'm trying to just get the dtexec utility to work. I believe i'm either doing something wrong or have found a bug, as i've used this in the past at another company without any issue.
Here's the cmd line that I'm using (I'm using the 32 bit version of dtexec):
E:Progra~1Micros~190DTSBinndtexec.exe /SQL "TestMsgBox" /SERVER D1PSQL02V /CHECKPOINTING OFF /REPORTING EW
The version of the dtexec file is: 2005.90.3042.0
Any help would be greatly appreciated.
Andy
Hello,
I have many problem when I try to install SQL 2005 Ets edition ia64 on a 2003 ets Itanium edition.
When I launch the setup, all is all right. But during the installation, it tryes to start MSSQL services.
The staring of this service failed. So I try to start the service mannually. Nothing.
Error messages I can get (in the event log) :
Source : Service Control Manager ; ID : 7000
Description :Service SQL Server (MSSQLSERVER) failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
Source : MsiInstaller ; ID 10005
Description : Product: Microsoft SQL Server 2005 (64 bits) -- Error 29503. Failure of the starting of service SQL Server. For more information, to see the headings of on line help €śProcedure: to post the files newspapers of installation of SQL Server 2005€? and €śmanual Starting of SQL Server€?. This error is (1053) The service did not respond to the start or control request in a timely fashion.
HELPPPPP PLEEEAAAASSEEEEEE !!!!!!!!!! ;-)
Hi,
we work with the Reporting Services of the Itanium Edition of SQL Server 2005. With some reports (only some) we have the problem that
very long time is needed for the processing of the report. I checked the ExecutionLog table in my Reportserver database and detected that
values in the column TimeDataRetrieval (TDR) or pretty slow, but them in the column TimeProcessing (TP) are very high.
Report1: TDR = 8304ms TP = 34377ms .
In other (most) reports the values are completely different
Report2: TDR 8336ms TP = 233ms
Now the most interesting thing: When I execute the same report on our test server which is a xeon machine (same data volume, no user workload)
I get the following results:
Report1: TDR = 5244ms TP = 11731ms
Report2: TDR = 4750ms TP = 163
The differences in TimeDataRetrieval (TDR) should be ok, because the machine is used by over 700 people
and so the response times of the Analysis Server database could differ.
Report1 and 2 do not differ too much in complexity. A few groupings, parameters and so on.
The Itanium machine is a 2 way dual core system with 16 Gigabyte RAM.
The Xeon machine is a 2 way xeon system with 8 Gigabyte RAM (32bit processors).
What is going on there? How could I optimize the TimeProcessing of Report1 on the Itanium machine? Which performance counters or tools should I use to go
deeper finding out where the problem is?
I am working on a project to write SSIS packages to update a SQL Server 2005 database with data from an Oracle 10g database. Unfortunately, our development ETL box is running 32 bit Windows Server 2003 while the production ETL box is running 64 bit Itanium Windows Server 2003. We have created SQL Server Agent jobs to execute all of our packages. All of our jobs run without error on the 32 bit development box, but in our preproduction tests they are failing in the 64 bit box.
In my testing, I've found that I can successfully pull character data from Oracle. For example, I can write a package that retrieves the data for the following query:
SELECT 'test' FROM dual
However, the following fails:
SELECT 1 FROM dual
I have logging turned on in my package. When the package fails, I typically see informational messages in the log up to the point of failure, but no actual error event logs are generated. The only error information I have is in the SQL Server Agent job history log, which contains the following:
Executed as user: SERVERNAMESYSTEM. The return value was unknown. The process exit code was
-2147483646. The step failed.
I have also tried using the 64 bit version of the DTS Wizard to create a sample package, and observe the same behavior. When I run the DTS Wizard, queries that return numeric data cause DTSWizard.exe to exit and produce the following message in the application event log:
Event
Type: Error
Event
Source: .NET Runtime 2.0 Error Reporting
Event
Category: None
Event
ID: 1000
Date:
2/1/2007
Time:
12:36:13 PM
User:
N/A
Computer: SERVERNAME
Description:
Faulting
application dtswizard.exe, version 9.0.2047.0, stamp 443f5e50, faulting module
oracore10.dll, version 10.2.0.1, stamp 435841b0, debug? 0, fault address
0x00000000001e4910.Has anyone else experienced similar behavior, and know of a solution aside of wrapping all retrieval of numeric data in to_chars in our Oracle queries?
We are migration few database from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server)
Problem :
- The performance difference observer was not much (Just 15-18%)
- The CPU Utilization goes to 100% immediately, when the software login screen appears and it sustains in between 90% to 100%
- Multi-User Access (3 or more concurrent users), the sql performance is tremendously slow.
Steps followed for Migration:
- We have used the backup and restore method to migrate the data from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server).
- We ran the DBCC DBREINDEX for each affected tables
- We executed the sp_updatestats procedure for all the tables
- Upgraded the DB compatibility version to 90
- Installed the SQL 2005 Enterprise Server (64 bit-Itanium Server) Service pack 2.
One thing that we observed, was the memory usage, on SQL 2000 the sqlservr.exe uses around 1.5 GB where as on the SQL 2005 its just 120 MB.
A normal select query on 2000 Server took 11-12 sec, having 10 lac records, and the same query on 2005 took 1 min (3-5 sec CPU process taken by sqlservr and rest by the Sever Management Studio.
The only differance noted was that on 2000 the entire data was displayed at one go where as in 2005 the data was displayed at the 1st sec, and was filling the rest in the buffer, and to finally display entire data it took 1 min.
Also
when we run this query
select * from sys.dm_os_sys_info
one column os_priority_class shows a value = 32 ? what does this means.
In the MSSQLSERVER SERVICES, properties, there is a parameter displaying value
Advanced > Running Under 64 bit OS = No ? what does this means.
Could anyone pls suggest as to how to increase the sqlservr.exe memory area, and also how the enhance the performance.