Toad World® Forums

ERROR "Implicit test elements are not cached successfully" when I try to create a test definition around a function


#1

ERROR “Implicit test elements are not cached successfully” when I try to create a test definition around a function.

I am using the latest version. I saw there was a post around 3 yrs back on this…

http://www.toadworld.com/products/code-tester/code_tester_for_oracle_beta_program/f/99/t/13239.aspx

Was this ever resolved, I am seeing the same error.

Would be delighted if someone could help resolve this.


#2

Anyone…any inputs / thoughts / suggestions?


#3

Hi Swapnil,

I am investigating your case now.

Will let you know about my progress…

Thanks,

Leonid Khukhlovich

Software Developer Lead

Dell | R&D, Quest Software

office +1 847 899 4174

fax +1 775 548 9238


Quest Software is now part of Dell

From: Swapnil Parashar [mailto:bounce-Swapnil_Parashar@toadworld.com]

Sent: Wednesday, August 14, 2013 8:16 AM

To: codetestercustom@toadworld.com

Subject: RE: [Code Tester for Oracle - Customizing Your Test Definitions Discussion Forum] ERROR “Implicit test elements are not cached successfully” when I try to create a test definition around a function

RE: ERROR “Implicit test elements are not cached successfully”
when I try to create a test definition around a function

Reply by Swapnil Parashar

Anyone…any inputs / thoughts / suggestions?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Code Tester - Customizing your test definitions
notifications altogether.

Code Tester for Oracle - Customizing Your Test Definitions Discussion Forum

Flag
this post as spam/abuse.


#4

thanks…any luck??


#5

Hi Swapnil,

I have a couple of questions:

Are you still working with Code Tester 1.9? Is this freeware release?

Could you connect to your PTSD schema and run the following query:

SELECT
COUNT
(e.universal_id)
AS cnt

FROM
qu_test_element
e

WHERE
e.unit_test_guid

‘{A8A3C58C-601C-4AE1-BAD0-A5AC696267A9}’

UNION
ALL

SELECT
COUNT
(a.parent_guid)
AS cnt

FROM
qu_attributes
a

WHERE
a.usage_type

‘DEFAULT’

AND
a.parent_guid
IN

  (SELECT

e.universal_id

     FROM

qu_test_element
e

   WHERE

e.unit_test_guid

‘{A8A3C58C-601C-4AE1-BAD0-A5AC696267A9}’);

Please send me back 2 numbers that you will get as the result of this query.

Thanks,

Leonid Khukhlovich

Software Developer Lead

Dell | R&D, Quest Software

office +1 847 899 4174

fax +1 775 548 9238


Quest Software is now part of Dell

From: Swapnil Parashar [mailto:bounce-Swapnil_Parashar@toadworld.com]

Sent: Wednesday, August 14, 2013 9:44 AM

To: codetestercustom@toadworld.com

Subject: RE: [Code Tester for Oracle - Customizing Your Test Definitions Discussion Forum] ERROR “Implicit test elements are not cached successfully” when I try to create a test definition around a function

RE: ERROR “Implicit test elements are not cached successfully”
when I try to create a test definition around a function

Reply by Swapnil Parashar

thanks…any luck??

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Code Tester - Customizing your test definitions
notifications altogether.

Code Tester for Oracle - Customizing Your Test Definitions Discussion Forum

Flag
this post as spam/abuse.


#6

Hi Leonid

Thank you for getting back to me.

  1. The version I am using is 2.6.0.920g and it is a freeware release and says expires on 06 March 2014.

  2. I simply connected using the same user in SQL Developer and executed your SQL statement. I get CNT as 0 and 0, i.e. 0 for both numbers.

Let me know if anything else you want me to try.


#7

Hi Swapnil,

It looks like you repository is not good. The numbers should be 118 (both).

I propose you to reinstall your repository.

Thanks,

Leonid Khukhlovich

Software Developer Lead

Dell | R&D, Quest Software

office +1 847 899 4174

fax +1 775 548 9238


Quest Software is now part of Dell

From: Swapnil Parashar [mailto:bounce-Swapnil_Parashar@toadworld.com]

Sent: Wednesday, August 14, 2013 1:31 PM

To: codetestercustom@toadworld.com

Subject: RE: [Code Tester for Oracle - Customizing Your Test Definitions Discussion Forum] ERROR “Implicit test elements are not cached successfully” when I try to create a test definition around a function

RE: ERROR “Implicit test elements are not cached successfully”
when I try to create a test definition around a function

Reply by Swapnil Parashar

Hi Leonid

Thank you for getting back to me.

  1. The version I am using is 2.6.0.920g and it is a freeware release and says expires on 06 March 2014.

  2. I simply connected using the same user in SQL Developer and executed your SQL statement. I get CNT as 0 and 0, i.e. 0 for both numbers.

Let me know if anything else you want me to try.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Code Tester - Customizing your test definitions
notifications altogether.

Code Tester for Oracle - Customizing Your Test Definitions Discussion Forum

Flag
this post as spam/abuse.


#8

Hi Leonid

Thank you for the reply. I suppose by repository you mean I should re-install the database schema,

Appreciate your response, will get back to you after the re-install.

Thanks again.

Regards

Swapnil


#9

I mean Code Tester repository.

Go to Start->All programs->Quest Software->Quest Code Tester for Oracle->Administration->Install or Upgrade repository:

Then follow on screen instruction pressing “Next”.

Regards,

Leonid Khukhlovich

Software Developer Lead

Dell | R&D, Quest Software

office +1 847 899 4174

fax +1 775 548 9238


Quest Software is now part of Dell

From: Swapnil Parashar [mailto:bounce-Swapnil_Parashar@toadworld.com]

Sent: Wednesday, August 14, 2013 2:59 PM

To: codetestercustom@toadworld.com

Subject: RE: [Code Tester for Oracle - Customizing Your Test Definitions Discussion Forum] ERROR “Implicit test elements are not cached successfully” when I try to create a test definition around a function

RE: ERROR “Implicit test elements are not cached successfully”
when I try to create a test definition around a function

Reply by Swapnil Parashar

Hi Leonid

Thank you for the reply. I suppose by repository you mean I should re-install the database schema,

Appreciate your response, will get back to you after the re-install.

Thanks again.

Regards

Swapnil

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Code Tester - Customizing your test definitions
notifications altogether.

Code Tester for Oracle - Customizing Your Test Definitions Discussion Forum

Flag
this post as spam/abuse.


#10

Hi Leonid

The next screen asks for username, password and database.

Now is the database the server where the functions are, or should I just point to my own machine where the tests would be saved?


#11

Let’s clarify…

Code Tester (CT) works with the following schemas: Code Tester repository ® , tested schema (T), schema for generated testing code ©.

Different CT customers use different configurations:

·
R, T and C are 3 different schemas (R,T,C configuration)

·
when R, T and C are the same schema (R=T=C configuration).

·
T and C are the same schema and R is different (R, T=C configuration). This is the most popular option.

·
Instead of one T schema our customers sometimes use a number of schemas where tested programs and depended object are located (T1, T2, …).

When you install into existing schema the next screen ask you about R schema. After repository installation in the R schema you can see a number of QU% tables
and packages. Your test definitions will be saved there.

Testing code is a package that is generated on base of test definition. It is a package in C schema with Q## prefix in its name, which is run when testing.

When you use a configuration
different from R=T=C you should make sure you have enough privileges for testing.

T and C schemas should have privileges access/execute repository objects. The simplest way is to create public synonyms for repository objects. You can go:

Go to Start->All programs->Quest Software->Quest Code Tester for Oracle->Administration->Repository manager

You can create private synonyms using qu_private_synonyms.sql and qu_grant_execute.sql script coming with installation.

If you use “R,T,C configuration” the T schema should have execute/access privileges on tested object in T schema.

Regards,

Leonid Khukhlovich

Software Developer Lead

Dell | R&D, Quest Software

office +1 847 899 4174

fax +1 775 548 9238


Quest Software is now part of Dell

From: Swapnil Parashar [mailto:bounce-Swapnil_Parashar@toadworld.com]

Sent: Wednesday, August 14, 2013 4:10 PM

To: codetestercustom@toadworld.com

Subject: RE: [Code Tester for Oracle - Customizing Your Test Definitions Discussion Forum] ERROR “Implicit test elements are not cached successfully” when I try to create a test definition around a function

RE: ERROR “Implicit test elements are not cached successfully”
when I try to create a test definition around a function

Reply by Swapnil Parashar

Hi Leonid

The next screen asks for username, password and database.

Now is the database the server where the functions are, or should I just point to my own machine where the tests would be saved?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Code Tester - Customizing your test definitions
notifications altogether.

Code Tester for Oracle - Customizing Your Test Definitions Discussion Forum

Flag
this post as spam/abuse.


#12

Hi Leonid

The information you provided has been of great helped and the issue is finally resolved after re-installing the repository.

Really appreciate your quick and great responses.

Thanks again.

Regards

Swapnil