Cache issue in OTRS

[GMunjal]

Hi,

We implement OTRS, in which we use to fill the dropdown values from some external data source.

Once the values are filled in dropdown, and if then I add some more value in external data source. these will not reflect till I didn't delete the OTRS cache.

Is there is any way that whenever I update the external database, the same values will be reflected at the same time on UI or on refresh the page.

Any suggestions for this issue.

Thanks

[jojo]

you need to alter your script which gets the data to update the cache.

[GMunjal]

We create a simple extdata.pl and placed in bin folder which is used to get the external database, is there is any cache related code which cleans up the cache each time ?

below is the extdata.pl code :

Code: Select all

   my %CommonObject = ();
   $CommonObject{ConfigObject} = Kernel::Config->new();
   $CommonObject{EncodeObject} = Kernel::System::Encode->new(%CommonObject);
   $CommonObject{LogObject}    = Kernel::System::Log->new(
    LogPrefix => 'ExtData',
    %CommonObject,
   );
   $CommonObject{MainObject}   = Kernel::System::Main->new(%CommonObject);
   $CommonObject{DBObject}     = Kernel::System::DB->new(
      %CommonObject,
     DatabaseDSN  => 'DBI:ODBC:mssql',
     DatabaseUser => 'temp_test',
     DatabasePw   => 'test11',	
     Type         => 'mssql',
   );


	    	my $query = param('q') || '';
   		my $ResultAsArrayRef = $CommonObject{DBObject}->Prepare
		(
      			SQL => "select languageid from TRN_ODV where name like ?" ,
			Bind => [ \$query],
			Order => 'asc',
     			Limit => 1
   		);

#  my $json_text = to_json($ResultAsArrayRef);
#  print $json_text;
while ( my @Row = $CommonObject{DBObject}->FetchrowArray()) 
{
	 print  $Row[0] ;
}

[crythias]

Once the values are filled in dropdown, and if then I add some more value in external data source. these will not reflect till I didn't delete the OTRS cache.

This doesn't make sense.

The requests to your source data should not be cached.

[GMunjal]

Yes, you are right, that should not be cached. but in my scenario it is cached, can you explain the way that it must not be cached.

[GMunjal]

Yes, you are right, that should not be cached. but in my scenario it is cached, can you explain the way that it must not be cached.

[crythias]

You can browse through otrs/bin/otrs.DeleteCache.pl and see what minimal entries you'd need to add the extdata.pl file.