Search results for query: *

Hi, I need to output rejected records with the reject reason directly to a db table instead of the reject file. I have been playing with output filters and using derivatives to capture the rejected record properties but haven't been successful. Does anyone have any experience with this? Thank you

Hi, We are getting this error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" when executing a job or build from a client server to the ETL server. how do we work around this issue? Thank you, Paul

Hi, I am using the following shell script command to rename backkup files. FOR /F "tokens=2-4 delims=/ " %%A IN ('Date /T') DO REN finance_pnl_analysis.mdc %%C-%%A-%%B-finance_pnl_analysis.mdc It works perfectly on one server in a command file for a different backup. When I run the same...

Hi, I have cubes where I have to create custom views that are very fine in detail and I have to create a lot of them for different user classes. I have also noticed that if I clean house on a dimension, the custom view gets destroyed if I have excluded certain categories in the custom view...

Hi, Doing a Distributed install of Series 7 MR3 PPES on Windows 2003 Servers. PPES is on one server, connecting to two IIS web servers and using Active Directory on Domain Servers. I know I install PPES and Upfront Dispatchers on the PPES server, and install Upfront,PPES Gateways on the IIS...

Hi, I am trying to configure the Cognos BI 7 version 2 suite using Sun One LDAP server. I have confirmed my DN in Sun One and have put the base DN in Access Manager-Directory Services-General, applied and it was okay. However, in Access Manager-Runtime-Directory Server with the correct DN I am...

Hi, first the background: I have my navigation HTML control hyperlinks in a User Control which is loaded onto my page (it is actually using a template). The Application start page is MyApp/Default.aspx. A user is redirected to a sub directory Default.aspx page upon authentication. In this...

Hi, I have just installed jakarta-tomcat-4.1.24-LE-jdk14. I have also installed the j2sdk1.4.2. After starting tomcat I am unable to pull up the tomcat web test web page. I am on Win 2k Pro SP 4. I have set all environment variables (JAVA_HOME,CATALINA_HOME etc.) as listed in the...

Hi, I am unable to install SQL Server on a Windows 2000 Server box. The error returned is "SQL Server does not exist or access denied". Here is the failure section from sqlstp.log: Starting Service ... SQL_Latin1_General_CP1_CI_AS -m -Q -T4022 -T3659 Connecting to Server ...

Hi, I'm new to .Net and am trying to connect a client to a Web Service. I am connecting on a local machine. I know the Web Service is working because I can connect and test it in both Visual Studio and by URL in my web browser. When I put the URL in the address box of the "Add Web...

Hi, I am trying to move large amounts of data from one oracle db to another. Tablespace moves are not useful. I have been instructed to use the COPY commmand. It is working well for tables that do not have FLOAT datatype. However it errors on those tables with FLOATS. Oracle documentation...

Hi, whenever I try and use Oracle functions in my control files I get an Oracle error. The syntax I try is right out of a SQL loader manual. I am starting to suspect that there may be some env variables or something that are stopping SQL*Loader from finding the Oracle functions. Does anyone have...

Hi, I am new to sed. I have to modify a tab delimitted text file that is not formatted correctly for my use. I have to do a replacement. I have date fields that are formatted like this: mm/dd/yyyy. If the date field is null, the file is outputting / / . If I know what number tab the...

Hi, The data source files I am trying to load have a " / / " mask when the date column is null. Does anyone know how to deal with this. Is there an oracle function in 8.1.7 that can test for a valid date like the VB function IsDate()? Thank you

I am trying to invoke SQL*loader on a Sun OS box. Oracle 8.1.7 is installed on the machine and I am connecting to the database on the box. the set command shows that the oracle bin directory is in the path. However when I type in sqlldr I get this error: Message 2100 not found; No message file...

I want to assign a formatted date to a variable and then add the date variable to the name of a log file. This doesn't work for the assignement RunDate= Date '+%y-%m-%d' How would I get the variable assigment to work? how would I create a log file name that would look like this? # variables...

Hi, I do most of my work in MS SQL and Sybase so these two questions may not make much sense in Oracle. I am loading data from a remote server on to a local Oracle server. Once on the local server I am transforming the data. In MS SQL and Sybase, I usually put my initial loaded data into a...