Posted Tue, 03 Jul 2018 18:37:21 GMT by Casey Miller Director of Technical Services

We are receving this error when trying do a query on a field called EMPLOYEE. I convert the query data to base64 and also the login data to base 64 and then encrypt that using AES-128-CBC.  I get the error listed below.


The request could not be served.


500 - Internal Server Error




IntegrationInvalidParameterException: DocuWare.Gapi.Utils.Web.DWIntegration.EX_INVALID_PASS_PHRASE


I know this passphrase is correct because I can open URL creator and use it and it works fine. Any ideas here?


Here is the code being used from the Intranet of the company.


ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);


function encryptor($action, $string) {
    $output = false;
    $encrypt_method = "AES-128-CBC";
    //pls set your unique hashing key
    $secret_key = 'THEPASSPHRASE';
    $secret_iv =  'THEPASSPHRASE';
    // hash
    $key = hash('sha512', $secret_key);

    // iv - encrypt method AES-256-CBC expects 16 bytes - else you will get a warning
    $key = substr(hash('sha256', $secret_key), 0, 32);
    $iv = substr(hash('sha256', $secret_key), 32, 16);

    //do the encyption given text/string/number
    if( $action == 'encrypt' ) {
 //       $output = openssl_encrypt($string, $encrypt_method, $key, $options=OPENSSL_RAW_DATA, $iv);
        $output = openssl_encrypt($string, $encrypt_method, $key, 0, $iv);
         $output = base64_encode($output);
    else if( $action == 'decrypt' ){
        //decrypt the given text/string/number
        $output = openssl_decrypt(base64_decode($string), $encrypt_method, $key, 0, $iv);
    return $output;

function base64url_encode($plainText)
    $base64 = base64_encode($plainText);
    $base64url = strtr($base64, '+/', '-_');
    return ($base64url);

<script type="text/javascript">
function openit(URL,width,height)
    var width;
    var height;
    var newWindow, args = "";
    args += "height=" + height + ",width=" + width;
    args += " ,menubar=yes, titlebar=yes,dependent=yes,scrollbars=yes,resizable=yes";
    var popup ="", "_blank", args) ;
    popup.location = URL;


$User = 'USER';


//  Setup query 
$Qry = '[EMPLOYEE__]='.trim($User);
$QrySelect = '&q='.base64url_encode($Qry);

$login = 'User=Training User\nPwd=USERPASSWORD';
$loginSelect = '&lc='.base64url_encode($login);

$ep = $loginSelect.$QrySelect;
$epencrypt = encryptor('encrypt', $ep);


$EditCourseLink = 'http://docuware-01/DocuWare/PlatformRO/WebClient/1/Integration?ep='.$epencrypt;

echo "<table width='100%' cellspacing='0' cellpadding='0' border='0'>";
echo "</tr>";
echo "<tr>";
echo "<TD width='15%' align='center' >
<button type='button' class='button' onclick=\"openit('$EditCourseLink',900,800)\">Certifications</button>";
echo "</td>";
echo "</tr></table>";


// testing only
echo $key;
ECHO '<BR><BR>';
echo $iv;
ECHO '<BR><BR>';

ECHO '<BR><BR>';
ECHO 'QRY='.$Qry;
ECHO '<BR><BR>';
ECHO 'QrySelect= '.$QrySelect;
ECHO '<BR><BR>';

ECHO 'login='.$login;
ECHO '<BR><BR>';
ECHO 'loginSelect='.$loginSelect;
ECHO '<BR><BR>';

echo $ep;
echo '<br><BR>';

echo 'epencrypt= '.$epencrypt;
echo '<br>';

echo $EditCourseLink;
echo '<br><BR>';

Posted Tue, 20 Nov 2018 05:07:51 GMT by Daniel Oppermann Ohra Energie GmbH Leiter IT / EDV


gibt es zu dem Problem bereits eine neue Erkenntnis oder konnte es gelöst werden. Wir stehen aktuell vor dem gleichen Problem,

Posted Tue, 20 Nov 2018 14:47:38 GMT by Casey Miller Director of Technical Services

Haven't gotten an answer yet on this from support

You must be signed in to post in this forum.