Recent content by ernstmik

I have a centralized tnsnames.ora file that I am trying to use to connect to an Oracle database. I have set the TNS_ADMIN variable in the system section of the Windows environment variables. I can tnsping the database I want to connect to and it returns positive results using the centralized...

I am currently running a clustered environment with 3 servers, two of which are running an APS, which we'll call APS01 and APS02. The APS database shared by the clustered environment is on an Oracle 9i server. APS01 and APS02 are rebooted weekly during an early Sunday morning maintenance...

In continuing the audit of the CE9 implementation I inherited, I periodically see the following error message in the Windows event log: "The schedule result provided by the Job Server for the object identified by 763954 is invalid." I couldn't find any reference to similar errors on the...

I need to be more careful with my wording. Will CE9's APS be able to use Oracle 10 as it's database? We currently have CE9 and it is using Oracle 9i as its database. Our database team wants to upgrade all Oracle 9i databases to Oracle 10. Oracle 10 is not listed on the Platforms.txt for CE9...

We are using an Oracle database for the APS. However as I am auditing our system, I have found that our APS database is residing on the same Oracle server that hosts 75 other Oracle databases used by clients to report from. These are very active databases and my concern is that they are...

Will CE9's APS database run on Oracle 10?

I am upgrading the hardware for our CE9 implementation. It has given me a chance to review some of how the settings currently in place which led me to this question. Can or should the APS database be sharing a database server that also contains the databases that the published reports are...

Can the APS database, currently residing on Oracle, have its indexes rebuilt? More importantly, should the APS database be periodically re-indexed?

Version: CE 10 Objective: We have one report that is scheduled to run and automatically print. We do not want any instances stored of that report. CE 10 will not allow me to set the instance count to 0, regardless of which limit option I choose. Any other ideas as to how to store 0 instances...

Is there a way to clean up the instances so that 0 instances are stored on the server? I can set the limit to 1 but when I attempt to set it to 0 it says it must be a positive number.

Most of the details are to be determined. It most likely will be an Oracle database but unfortunately, the team that wants to do this, is still in theoretical mode and hasn't made it that far along. Having said that, is there one data type that works best for images and PDFs that I could let...

If images and pdf files are stored in a database, can they be accessed by Crystal Reports?

Nobody uses LDAP?

I am trying to implement LDAP authentication on our CE10 server. Everything is going ok except for one thing. I've tried putting the cert7.db file in every possible directory I can think of but I cannot get CE10 to read it. Does anyone who has implemented LDAP know where the cert7.db file...

I found out what the problem was. The issue, which it always seems to be, was with the "to_date(complete_date) = to_date(sysdate)" statement in the the union statments. TOAD was able to use that as is but CR10 didn't respond to the to_date function. It didn't give errors, it just didn't...